Answer Posted / kunal gupta

select top 1 sal from (select top n sal from tbl_master
group by sal order by sal desc)m order by sal

This answer is easiest and 100% tested

How to use group functions in the select clause in ms sql server?

996

---

How to provide login information for a new odbc dsn?

981

---

What are the differences between user defined functions and stored procedures?

1007

---

Do you know exporting and importing utility?

974

---

Does sql server 2000 full-text search support clustering?

816

---

Explain “row_number()” in sql server with an example?

950

---

Explain triggers?

945

---

What are the new data types are introduced in sql 2000?

862

---

How to specify the collation for a character data type in ms sql server?

965

---

What is dknf in normalization form?

988

---

What is sql server agent and what are the two modes of authentication in sql server?

997

---

What is difference between stored procedure and user defined function?

1033

---

Can you force a query to use a specific index?

889

---

What are the operating modes in which database mirroring runs?

1028

---

Explain the difference between clustered and non-clustered index?

872

---