Question: general syntax for a SELECT statements

Ads

 
 
 

Share on Google+Share on Google+

hemant kumar
general syntax for a SELECT statements
1 Answer(s)      6 years and 6 months ago
Posted in : SQL

Write down the general syntax for a SELECT statements covering all the options

Ads
View Answers

November 20, 2010 at 12:05 PM


Hi,

The general syntax of a select statement covering all the options is as follows,

this syntax shows how we can use different optin with the select statements.

SELECT select_list
[INTO new_table_]
FROM table_source
[WHERE search_condition]
[GROUP BY group_by_expression]
[HAVING search_condition]
[ORDER BY order_expression [ASC | DESC] ;

Thanks,


Ads









Related Tutorials/Questions & Answers:
general syntax for a SELECT statements
general syntax for a SELECT statements  Write down the general syntax for a SELECT statements covering all the options   Hi, The general syntax of a select statement covering all the options is as follows, this syntax
Objective C if else statements syntax
Objective C if else statements syntax  What is the syntax of if else statements in Objective C?   Using of if else statement in Objective C There is no changes in the syntax format of if else statement. You can write
Advertisements
Using Select Statements in JDBC
Using Select Statements in JDBC    The SELECT statement is used to select data from a table. For terminating... is concern with Select Statements. You have to just create the connection
Understanding Common SQL statements
a table. Syntax: Select column_names FROM table_name... Understanding Common SQL statements       The commonly used SQL statements are: 1
Programming (general)
Programming (general)  I haven't yet started college/university but I'm interested in studying programming. I wondering if programming is difficult or confusing with all the codes you have to learn? Also how many languages would
predicates and statements?
predicates and statements?  Explain about predicates and statements
general layout HTML documents
general layout HTML documents  Explain the general layout HTML documents
The INSERT INTO Statements in SQL?
The INSERT INTO Statements in SQL?  The INSERT INTO Statements in SQL?   Hi, The INSERT INTO statement is used to insert a new row or multiple rows into a table. SQL INSERT INTO Syntax INSERT INTO table_name VALUES
General Question - Java Beginners
General Question  Sir, I'm the beginner about this course JDK 1.3 BlueJ Software. Hence, I want to learn from the beginning, as: 1)When I open the BlueJ Icon, the window appears. So, in that window there we use to see four menus
syntax for create a table
syntax for create a table  syntax for create a table
Account Management Statements
; CREATE USER Syntax The general syntax of CREATE USER statement is :  ... sec) DROP USER Syntax The general syntax of DROP USER statement... The general syntax of GRANT statement is: GRANT priv_type [(column_list)] [, priv_type
javascript comment syntax html
javascript comment syntax html  javascript comment syntax html
Text Editor with Syntax Highlighting
Text Editor with Syntax Highlighting   How to write a java program for text editor with syntax highlighting
TIBCO General Interface
TIBCO General Interface       First released in 2001, this mature Ajax framework enables you to create Ajax components and applications that have the look and feel of desktop GUIs
php header syntax
php header syntax  What is the correct syntax of PHP Header
JAVA Syntax - Java Beginners
JAVA Syntax  main method syntax in jdk1.3 with one example
php do while syntax
php do while syntax  How to create a do while loop in php. What is the syntax
Table Maintenance Statements
, RESTORE TABLE Syntax. ANALYZE TABLE Syntax The general syntax of ANALYZE TABLE... to the replication slave. BACKUP TABLE Syntax The general syntax of BACKUP TABLE... Note - This statement is depricated. CHECK TABLE Syntax The general
General Interview Question - IDE Questions
General Interview Question  Please provide soln for this question(wt are all the concepts we hav to add for this question).Explain Architecture of ur project in brief
MySQL Transactional and Locking Statements
TRANSACTION, COMMIT and ROLLBACK The general syntax of Start Transaction, commit... TO SAVEPOINT  The general syntax of SAVEPOINT and ROLLBACK TO SAVEPOINT... TABLES and UNLOCK TABLES The general syntax for locking and unlocking the tables
syntax problem - Java Beginners
syntax problem  Hi , Im loading a particular css class for a specific div id using the syntax shown below.Please tell me what is the syntax if i have to perform a "not equal to check" fo the class name mentioned below
Java Control Statements
and for) . It also terminates the switch statements. Syntax:  ... Java Control Statements     ... the control statements. Different types of control statements: the decision making
main() syntax - Java Beginners
] [import statements] [class declaration] [main() method] For Example: package
sql syntax error help
sql syntax error help  this query show syntax error .. i am unable to figure it out insert into order (orderdate, dpname, paymethod, tamount, pquantity,shipid) values(now(),'$dpname' ,cod, '$tamount', '$itmqty', '$ship_id
heap and stack in general programming language
heap and stack in general programming language  what's the difference between heap and stack ?   Hi Friend, Differences: 1)Stack is referred as temporary memory while Heap is referred as permanent memory. 2)In stack
Control Flow Statements in java 7
Control Flow Statements in java 7 In this section we will discuss Control Flow Statements in java 7. This is one type of Language Fundamentals. Control Flow Statements : - In general program execution flow is from top to bottom
DECESION MAKING STATEMENTS
DECESION MAKING STATEMENTS  The Decision Making statements may be implemented in different forms depending on the complexity of the condition to be tested. Describe various forms of decision making statements in java
Java as a general purpose language
Java as a general purpose language       Java is an Object oriented application programming language developed by Sun Microsystems. Java is a very powerful general-purpose
Tutorials   
Java Spring Hibernate Struts Training How to Fetch Data using dropdown option How to get day from date in SQL? Example of sorting results in MySQL Distinct and Limit example in MySQL How to download install and use MySQL workbench? Example of Average, Sum, Min and Max functions in MySQL How to delete data from MySQL? Update SQL Query Example Order by example in MySQL AND and OR Operators in MySQL Query Where clause with query in MySQL How to use select Statement in MySQL? How to insert data into MySQL Table? Create Database and tables in MySQL example of before insert trigger in mysql Failed to Call Procedure MY Sql Query Error - Not able to Understand the issue which query will be run for previous(button) question How to access data yearly from DB in C# ? Fastest way to upload huge raw data in database - c#, Java or stored procedure DB Insert Nb hours between 2 time stamps meets specific criteria mysql select into table from another table example MySQLselect into new table Example code How to create a .mdf file from script (.sql) Please help me out fixing broken relational links in MySQL database after an upgrade How do I upgrade mysql? mysql 4.x to 5.x upgrade problem Upgrading a PHP/MYSQL application? upgrading sql query join phpmyadmin in whm whm php version update php cpanel cpanel mysql downgrade cpanel mysql version upgrade mysql whm upgrade mysql 4 5 cpanel upgrade mysql cpanel server Did my upgrade from mySQL 5.1 to 5.5 work Upgrade to MySQL 5.5 ? - cPanel Mem use upgrade from MySQL 5.1 to 5.5 - cPanel Upgrading MySQL from 5.0 to 5.1 or 5.5 - cPanel Mysql Upgrade on WHM (Mysql 5.1 to 5.5)cPanel Mysql Upgrade on WHM (Mysql 5.1 to 5.5) - cPanel Updating from MySQL 5.0 to 5.5 cPanel MySQL 5.1 upgrade to 5.5 error Charset problem upon publishing PHP + MySQL website MySQL issue: Table 'data_dictionary.CHARACTER_SETS' doesn't exist SQL Error Version 5.5.15

Ads

 
Advertisement null

Ads