Difference between truncate, delete and drop commands?

0 Answers  

---

Hi, Can anybody please explain me the flow of the below query. I am not able to understand how this query works. This query is for finding the Nth highest salary.. SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal); If N = 2 then second highest salary will be the o/p. If N = 3 then third highest salary will be the o/p. and so on.. Thanks, Nitin

5 Answers   Deloitte, Ness Technologies,

---

What is user in sql?

0 Answers  

---

i have a table emp and columns ename,empno,mgr_id,i need ename,manager name as result i.e employee respective manager.. example empno ename mgr_id 1 john 3 2 paul 3 3 smith 1 4 kevin 1 5 stewart 2 result has to look like this ename manager john smith paul smith smith john kevin john stewart paul can u plz help me out in this.....

8 Answers  

---

What is a loop in sql?

0 Answers  

---

How many types of tables are there?

0 Answers  

---

What type of database is sql?

0 Answers  

---

How can we make an if statement within a select statement?

0 Answers  

---

What is materialized view in sql?

0 Answers  

---

What is a mutating table

5 Answers   TCS, Tech Mahindra,

---

What is the primary use of normalization?

0 Answers  

---

Is it possible to use LONG columns in WHERE clause or ORDER BY?

3 Answers  

---