Answer Posted / aman kaushal

select salary from customer order by salary desc limit n,1;

here n is the array value 1st highest value starts with 0
value and then 1.

e.g

find the 2nd highest salary.

select salary from customer order by salary desc limit 1,1;

what is a self join? Explain it with an example? : Sql server database administration

885

---

What is database replication?

1079

---

What is the difference between having clause and where clause in sql server?

1033

---

what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

852

---

Explain the concepts and capabilities of sql server?

923

---

How to transfer an existing table from one schema to another schema in ms sql server?

927

---

Explain how to integrate the ssrs reports in application?

945

---

How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

1962

---

What is a not null constraint?

977

---

What do you understand by the analysis services in sql server?

895

---

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

950

---

What type of Index will get created after executing the above statement?

1047

---

What is compound operators?

978

---

How to automatically create a log when an exception is being received into SQL Server?

1213

---

How to create function with parameter in sql server?

1041

---