what is the correct way of selection statement
a. select/from/table_name/orderby/groupby/having
b. select/from/table_name/groupby/having/orderby
Answers were Sorted based on User's Feedback
Answer / kavitha nedigunta
b. select/from/table_name/groupby/having/orderby
EG: select deptno,max(sal)
from emp
group by deptno
having max(sal)> 5000
order by deptno
Is This Answer Correct ? | 69 Yes | 1 No |
Answer / iamanocp
Answer is b.
b. select/from/table_name/groupby/having/orderby
Is This Answer Correct ? | 18 Yes | 0 No |
Answer / 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 |
Answer / subbu
both are wrong
from/table_name/group by/having/select/oderby
Is This Answer Correct ? | 3 Yes | 13 No |
Is join same as left join?
Why do we use joins?
what is msql? : Sql dba
What is sqlite used for?
difference between SQL and C
1 Answers Indus Software Technologies,
Is clustered index a primary key?
Hi Everyone, How to get fist and last record from a table in oracle? Thanks in advance
Explain the insert into statements in sql?
Which table is left in join?
What is the purpose of a secondary key?
what are date and time data types in mysql? : Sql dba
Why indexing is needed?