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

What has stored procedures in sql?

0 Answers  

I have one table and column is c1 pk, c2 not null,c3 not null and 200 row in it and i add c4 column and value, how can is possible

9 Answers  

What are % type and % rowtype?

0 Answers  

What is magic table?

6 Answers  

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

0 Answers  

how many sql dml commands are supported by 'mysql'? : Sql dba

0 Answers  

declare l1 number := null; l2 number :=null; begin if l1=l2 then message('equal'); else if l1<>l2 then message('not equal'); else message('else'); end if; end if; end; What will be the output ?

7 Answers   Oracle,

what is bcp? When is it used?

0 Answers  

How is indexing done in search engines?

0 Answers  

Explain autonomous transaction.

0 Answers  

What is normalization in sql?

0 Answers  

What is meant by user defined function?

0 Answers