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 sql server transaction log file?

1061

---

How to provide default values to stored procedure parameters?

1068

---

Define right outer join?

984

---

How to use old values to define new values in update statements in ms sql server?

1271

---

How many joins in sql server?

963

---

what is a deadlock? : Sql server database administration

1072

---

Explain nested trigger in sql?

1082

---

How to update a field in SQL after ALTERING a row?

1235

---

Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

1084

---

How would we use distinct statement? What is its use?

1072

---

Scalability, Availability, Integration with internet, etc.)?

2884

---

Explain what are the basic functions for master, msdb, model, tempdb databases?

984

---

What is a transact-sql statement?

1067

---

Write the queries for commands like Create Table, Delete table, Drop Table etc.

1116

---

How to modify an existing stored procedure in ms sql server?

1083

---