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 is a unique constraint?

1016

what is top in tsql? : Transact sql

1026

what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

978

How can you select unique records from a table?

995

What are inner and outer joins examples of both?

881

What does where 1/2 mean in sql?

1011

What is pl sql quora?

1072

What is the difference between partition and index?

926

Is ms sql traffic encrypted?

875

Why do we use subquery?

944

what is datawarehouse? : Sql dba

955

How do I write a cron which will run a sql query and mail the results to agroup?

915

what is the difference between join and union? : Sql dba

1030

What are the uses of sysdate and user keywords?

1053

What is the difference between function, procedure and package in pl/sql?

1138