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

Can we write ddl statements in functions?

0 Answers  

---

What is a schema? How is it useful in sql servers?

0 Answers  

---

What is rownum in sql?

0 Answers  

---

can we create index on index?

7 Answers   iFlex, Symphony,

---

what is sp_pkeys? : Transact sql

0 Answers  

---

---

Why we use stored procedure instead of query?

0 Answers  

---

suppose we have values like 1 5 7 in a colum.Now we want numbers like(2 3 4 6) that exists between 1 5 7.How can we do this using sql query??

5 Answers   Keane India Ltd,

---

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

0 Answers  

---

Is sql open source?

0 Answers  

---

if we give update table_name set column_name= default. what will happen? its given in pl sql block.what will hapen?

5 Answers   iFlex,

---

What is trigger and types?

0 Answers  

---

What is sql injection owasp?

0 Answers  

---