Answer Posted / ankur bakliwal

I think this should work -


select top 1 salary from employee where salary in (select
distinct
top n salary from employee order by salary desc) order by
salary asc

Can We Use Data-grids For Our Report In Ssrs?

188

---

What is relationship? What number of sorts of relationship are there?

1224

---

What is the concept of optimization?

1111

---

What are SSL and TSL protocols?

1034

---

What is database white box testing?

1178

---

What is store procedure?

1116

---

How to rename an existing column with sql server management studio?

1055

---

What is a view and what are its advantages?

1170

---

What is @@error in sql?

1109

---

What is the difference between ddl and dml?

1101

---

Can you force a query to use a specific index?

993

---

What is standby servers? Explain types of standby servers.

1058

---

Explain where clause?

1034

---

Is it true, that there is no difference between a rule and a check constraint?

1113

---

When would you use it?

1043

---