How to read 2nd highest sal from EMP table?

5 Answers   IBM, TCS,

---

Hi all, I need query help for below senorio, could you please help me. TableName = City CITYID ContinuationID CITYNAME 1 1 SAN 1 2 DIEGO 2 1 SAN 2 2 FRANCISCO 3 1 CHICAGO 4 1 NEW 4 2 YORK 4 3 CITY Could you please help me to write a generalized SQL that returns results as given below in the Query result CITYID NAME1 NAME2 NAME3 NAME4 NAME5 1 SAN DIEGO 2 SAN FRANCISCO 3 CHICAGO 4 NEW YORK CITY

5 Answers   TCS,

---

Is null in sql server?

0 Answers  

---

What is the native system stored procedure to execute a command against all databases?

0 Answers  

---

Write the syntax for stuff function in an sql server?

0 Answers  

---

What is the use of sql profiler in sql server 2012?

0 Answers  

---

What is the impact on other user sessions when creating indexes?

0 Answers  

---

What is the difference between SQL notification and SQL invalidation?

0 Answers   MindCracker,

---

An employee table, with the columns id, name, sal and dob. Query to select emp names of all highest salaries(there are 4-5 people having the same salary which happens to be the highest).

9 Answers   ADP,

---

What is the difference between windows authentication and sql server authentication

7 Answers   HCL,

---

Is sql server 2016 free?

0 Answers  

---

What is a view in sql?

0 Answers  

---