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

Should I use mbr or gpt?

966

What is data profiling in sql?

1030

Explain the purpose of %type and %rowtype data types with the example?

947

What is equi join in sql?

1026

Is record in oracle pl sql?

915

What does desc stand for?

1035

What is the difference between distinct and unique in sql?

892

Explain select statements in sql?

1017

Why truncate is used in sql?

953

What are triggers and its uses?

1011

how to enter characters as hex numbers? : Sql dba

1004

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

958

What are sql*plus environment variables?

1052

how to fetch common records from two tables? : Sql dba

1124

Can we call procedure in select statement?

991