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

What are functions in sql?

962

How do we accept inputs from user during runtime?

1071

Why indexing is needed?

993

What is difference between table and view?

1065

What is union?

1178

What is a primary key called that is made up of more than one field?

1354

what are the advantages and disadvantages of cascading style sheets? : Sql dba

1064

What is data manipulation language?

1193

What is difference between my sql and sql?

1079

How do I find duplicates in two columns?

1175

How do I enable sql encryption?

1035

What are pl/sql packages?

1107

Which software is used for pl sql programming?

993

What are sql*plus environment variables?

1099

How do I run a sql query?

1028