SQL Server Interview Questions and Answers
<< Previous Question Next Question >>
 Question: 1358 Page Views: 

Write down the general syntax for a SELECT statement covering all the options.



Posted By: Avi Date: 19 September 2009 04:24:23 AM
 Answer:

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]]

*Statements written in brackets are optional.


Posted By: eTechPlanet

Date: 19 September 2009 04:24:23 AM
Post a better Answer if you have
 
(Will show your Gravatar icon)  
  Country flag

Loading
Enter the text as shown in the image qgXA0l
Related Questions
SQL Server : Which clauses are not supported by VIEW Creation Statement?

Which clauses are not supported by VIEW Creation Statement?

While creating a VIEW one can not use ORDER By,COMPUTE BY,COMPUTE clauses. Also INTO Keyword and tem....
Category: SQL Server Date: 10/1/2010 12:26:08 PM
SQL Server : Point out some disadvantages of CURSORS?

Point out some disadvantages of CURSORS?

1. They Keep the network busy because of there roundtrip. 2. It is time consuming , so decreases th....
Category: SQL Server Date: 10/1/2010 12:25:08 PM
SQL Server : What do you mean by Heap Table?

What do you mean by Heap Table?

These are the tables without clustered Indexes and possses one row in sys.partitions with index_id=....
Category: SQL Server Date: 10/1/2010 12:23:08 PM
SQL Server : What is the maximum number of tables and views allowed in a FROM Clause?

What is the maximum number of tables and views allowed in a FROM Clause?

It has been ristricted to maximum of 16 tables and views.
Category: SQL Server Date: 10/1/2010 12:22:08 PM
SQL Server : How many conditions can be included under WHERE Clause in SELECT statement?

How many conditions can be included under WHERE Clause in SELECT statement?

No limit specified.
Category: SQL Server Date: 10/1/2010 12:21:08 PM
 
Signup for our weekly email newsletter
email newsletter
Questions Categories