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
Who are end users in dbms?
What is the database development process?
How to replace not in with not exist?
Write short notes on manual refreshes.
How to customize error conditions.
Explain about relational operator join?
How would you design a database for an online site, which would average a million hits a day?
What is an application role and explain a scenario when you would use one?
Explain about relational database management systems?
On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?
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 the maximum length of an extended property?
How long can an error message be in raiseerror function?
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?
Explain what a database is?