How to find 6th highest salary from Employee table ?

10 Answers  

---

What samples and sample databases are provided by microsoft?

0 Answers  

---

Why we use the openxml clause?

0 Answers  

---

Define primary key?

0 Answers  

---

Write the Syntax for Cursors.

2 Answers   CarrizalSoft Technologies, HP,

---

What Is The Difference Between Primary Key & Super Key

3 Answers   Accenture,

---

what is a check constraint?

0 Answers  

---

how to delete duplicate rows in sql server2005

7 Answers   Cisco, CTS, HCL, IBM,

---

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,

---

how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?

0 Answers   Facebook,

---

How to enter date and time literals in ms sql server?

0 Answers  

---

What is the use of keyword with encryption. Create a store procedure with encryption?

0 Answers  

---