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



what is the correct way of selection statement a. select/from/table_name/orderby/groupby/having b...

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

what is the correct way of selection statement a. select/from/table_name/orderby/groupby/having b...

Answer / iamanocp

Answer is b.
b. select/from/table_name/groupby/having/orderby

Is This Answer Correct ?    18 Yes 0 No

what is the correct way of selection statement a. select/from/table_name/orderby/groupby/having b...

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

what is the correct way of selection statement a. select/from/table_name/orderby/groupby/having b...

Answer / abhishekjaiswal

It's Ans(b).

Is This Answer Correct ?    1 Yes 2 No

what is the correct way of selection statement a. select/from/table_name/orderby/groupby/having b...

Answer / subbu

both are wrong

from/table_name/group by/having/select/oderby

Is This Answer Correct ?    3 Yes 13 No

Post New Answer

More SQL PLSQL Interview Questions

Is join same as left join?

0 Answers  


Why do we use joins?

0 Answers  


what is msql? : Sql dba

0 Answers  


What is sqlite used for?

0 Answers  


difference between SQL and C

1 Answers   Indus Software Technologies,






Is clustered index a primary key?

0 Answers  


Hi Everyone, How to get fist and last record from a table in oracle? Thanks in advance

13 Answers   IBM,


Explain the insert into statements in sql?

0 Answers  


Which table is left in join?

0 Answers  


What is the purpose of a secondary key?

0 Answers  


what are date and time data types in mysql? : Sql dba

0 Answers  


Why indexing is needed?

0 Answers  


Categories