Answer Posted / gaurav mishra

The answer query is......

Select max(sal) from emp a where (&N-1) in(select count
(distinct(b.sal)) from emp b where a.sal<b.sal);

How can use stored procedures in sql?

1134

---

Write a sql query to get the third highest salary of an employee from employee_table?

1067

---

what is the difference between where clause and having clause? : Sql dba

996

---

How can get second highest salary in sql?

983

---

What is the difference between subquery and correlated query?

1063

---

What is the difference between explicit and implicit cursors in oracle?

1064

---

What is the difference between clustered and non-clustered index in sql?

1013

---

How delete a row in sql?

992

---

What is nosql db?

964

---

What is faster join or subquery?

1009

---

What's the difference between inner join and left join?

999

---

table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

4279

---

What are the types of dbms?

971

---

What is the size of partition table?

1043

---

what are the advantages and disadvantages of cascading style sheets? : Sql dba

1057

---