How to retrieve a second highest salary from a table? Note:Suppose salaries are in duplicate values eg: Name Sal Malli 60000 Pandi 60000 Rudra 45000 Ravi 45000

10 Answers   Mind Tree, Polaris, Sonata,

---

What is exit statement?

0 Answers  

---

What is implicit cursor in pl sql?

0 Answers  

---

Is sql open source?

0 Answers  

---

What is the use of non clustered index?

0 Answers  

---

---

What is magic table?

6 Answers  

---

What is the purpose of the sql select top clause?

0 Answers  

---

How many times can we commit in a loop?

0 Answers  

---

what is outer join? what is selef join? what is difference between them? what is cartecion join?

1 Answers   Fiserv, Herbinger, Synechron,

---

Why select is used in sql?

0 Answers  

---

What is PL/SQL Records?

0 Answers  

---

SELECT category, type, AVG(price) FROM products GROUP BY category, type ORDER BY 1, 2 If there are three distinct categories in the "products" table, and each one has five different types, how many rows are returned by the query above? 1. 1 row 2. 3 rows 3. 5 rows 4. 8 rows 5. 15 rows

3 Answers  

---