b. select/from/table_name/groupby/having/orderby EG: select deptno,max(

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

Question Posted / kavitha nedigunta

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

How bulk collect improves performance?

984

how do you know if your mysql server is alive? : Sql dba

1062

What does closing a cursor do?

1301

How do you rename a table in sql?

1084

Is sql injection illegal?

1003

What is data control language (dcl)?

1113

what is subquery? : Sql dba

1109

What is the difference between inner join and outer join?

972

How do I run sql?

1148

Explain the components of sql?

1042

What is view explain with example?

919

How to process query result in pl/sql?

1103

What can sql server reporting services do?

1095

What is normalization sql?

1037

what are set operators in sql? : Sql dba

1022