Explain the general syntax for a SELECT statements covering
all the options.
Answer Posted / us
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]
| Is This Answer Correct ? | 12 Yes | 1 No |
Post New Answer View All Answers
Write the fastest query to find out how many rows exist in a table?
You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?
What are the three basic rules which are to be followed for the relational model of the database?
What is dbms explain in brief?
How to use online Backups?
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
How can you log an error to the server event log from a stored procedure?
What is normalization? Explain different levels of normalization?
What are the main phases of database development?
What is the maximum length of an extended property?
What are the types of database model?
Write short notes on manual refreshes.
I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS
What is a database development?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?