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 is rollback? : Sql dba

0 Answers  

---

Can you do multiple joins in sql?

0 Answers  

---

what is the difference between primary key and unique key? : Sql dba

0 Answers  

---

In pl/sql, what is bulk binding, and when/how would it help performance?

0 Answers  

---

Is sql between inclusive?

0 Answers  

---

---

How do you write a complex sql query?

0 Answers  

---

how to create a new table in mysql? : Sql dba

0 Answers  

---

what is the main difference between join and subqurey?

3 Answers   Oracle,

---

what are myisam tables? : Sql dba

0 Answers  

---

How does stored procedure reduce network traffic?

0 Answers  

---

How to select random rows from a table?

0 Answers  

---

Practice 1: Changes to data will only be allowed on tables during normal office hours of 8.45 in the morning until 5.30 in the afternoon, MONDAY through FRIDAY. A. Create a procedure called SECURE_DML that prevents the DML statement from executing outside of normal office hours, returning the message: “you may only make changes during normal office hours” b. Create a statement trigger on the PRODUCT table which calls the above procedure. c. Test it by inserting a new record in the PRODUCT table.

1 Answers   Tech Mahindra,

---