Answer Posted / dilip

SELECT MIN(SALARY) FROM tablealies.Table_Name WHERE SALARY
IN (SELECT DISTINCT TOP N MAX(SALARY) FROM
tablealies.Table_Name ORDER BY SALARY DESC)

Define model database?

979

---

How to create a login account in ms sql server to access the database engine using "create login" statements?

1143

---

Can a cursor be updated? If yes, how you can protect which columns are updated?

1110

---

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

1952

---

What is service broker?

1005

---

What is tablix?

162

---

How would you use user_constraints table in DB?

1008

---

Tell me about the approaches which you used to counter the DI problems.

1353

---

What is the xml datatype?

1073

---

How to rebuild indexes with alter index ... Rebuild?

1127

---

How to test subquery results with the exists operator?

1107

---

What is difference between inner join and join?

1044

---

What is a covered index?

939

---

How to delete an existing row with delete statements in ms sql server?

1093

---

What are the different types of replication are there in sql server 2000?

1043

---