what is the correct way of selection statement
a. select/from/table_name/orderby/groupby/having
b. select/from/table_name/groupby/having/orderby
- 5 Answers
- 12880 Views
- HCL, JPMorgan Chase, I also Faced
- E-Mail Answers
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
Can you sum a count in sql?
What are the set operators in sql?
Can we use loop in sql?
How many sql commands are there?
What is pl sql collection?
What is autocommit sql?
explain the difference between bool, tinyint and bit. : Sql dba
What are different functions in sql?
Can a varchar be a primary key?
What is set transaction?
how to create a test table in your mysql server? : Sql dba
What is record in pl sql?
Is not equal in sql?
What is sql dialect?
How long will it take to learn pl sql?
