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

Answer / iamanocp

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

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.

Answer / abhishekjaiswal

It's Ans(b).

Answer / subbu

both are wrong

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

How to download oracle sql developer?

0 Answers  

What is a .db file?

0 Answers  

Where the Pre_defined_exceptions are stored ?

2 Answers  

What is the difference between anonymous block and named blocks?

3 Answers  

What are the datatypes a available in PL/SQL ?

2 Answers  

Store procedure will return a value?

4 Answers   eMids,

Is pl sql and postgresql same?

0 Answers  

How can you fetch first 5 characters of the string?

0 Answers  

What is normalization ?

9 Answers   BirlaSoft, CTS, HCL,

What is bind reference and how can it be created?

0 Answers  

Dear All, Question for this Week Find out possible error(s) (either at compile time or at runtime) in the following PL/SQL block. State the reason(s) and correct the errors. Declare Cursor C1 is select ename, sal, comm from emp; Begin For i in C1 Loop If i.comm between 299 and 999 then Dbms_output.put_line(i.Ename || ‘ ** Good Commission’); Elsif i.comm > 999 then Dbms_output.put_line(i.Empno || ‘ ** Very Good Commission’); close C1; Else Dbms_output.put_line(i.Ename || ‘ ** ’ ||nvl(i.comm,‘O’)); End if; End Loop; End;

7 Answers   Accenture,

What are the different types of triggers?

0 Answers