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
- 12851 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
Explain sql data types?
Can a table contain multiple primary key’s?
what is union? : Sql dba
How do I run a sql query in pgadmin 4?
Describe different types of general function used in sql?
how to convert character strings to dates? : Sql dba
What are operators available in sql?
What mean sql?
What is meant by user defined function?
what is a stored procedure? : Sql dba
How do I count duplicates in sql?
what are the 'mysql' command line options? : Sql dba
What is the difference between left and left outer join?
What is dialect in sql?
Can we use loop in sql?
