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 parallel hint?
What is a primary key? Explain
What are variables in pl sql?
How to create a menu in sqlplus or pl/sql?
How do I view a view in sql?
what are the types of join and explain each? : Sql dba
what is clause? : Sql dba
How do you change a value in sql?
what are sequences
What is a primary key sql?
Can we use pl sql in mysql?
How can use stored procedures in sql?
How to add, remove, modify users using sql?
How do you bind variables in pl sql?
How does a trigger work?