what is the correct way of selection statement
a. select/from/table_name/orderby/groupby/having
b. select/from/table_name/groupby/having/orderby
Answer Posted / anil kumar jaiswal
the sequence is like this :
select
from
table_name
where
group by
having
order by.
where ever writing a sql query the sequence should be in this order.
so the answer B is correct.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is myisam? : Sql dba
What is exception? What are the types of exceptions?
Why is nosql good?
How do I run a pl sql procedure in sql developer?
How do you modify a trigger?
how to write date and time literals? : Sql dba
What is nosql db?
How do I kill a query in postgresql?
How to display the records between two range in Oracle SQL Plus?
Who developed sql?
what are the advantages of mysql in comparison to oracle? : Sql dba
How do I access sql anywhere database?
How do you rank data in sql?
What is union and union all keyword in sql and what are their differences?
Why use stored procedures?