Answer Posted / sharmila shree

SELECT TOP 1 salary FROM
( SELECT DISTINCT TOP 1 salary FROM table_name
ORDER BY salary DESC )
a ORDER BY salary

here 'a' is sub query of salary

What is a trigger in sql server?

1232

---

How do I find the sql server instance name?

1014

---

What are the difference between clustered and a non-clustered index?

1090

---

If no size is defined while creating the database, what size will the database have?

1036

---

What is the definition for sql server 2000?

1140

---

Explain indexes disadvantages?

1145

---

What are page splits? : SQL Server Architecture

1040

---

explain different types of cursors? : Sql server database administration

1148

---

What is named calculation? : sql server analysis services, ssas

1025

---

What is sql server replication? : sql server replication

1040

---

What do you mean by data integrity?

1129

---

What is default constraint?

1054

---

Describe in brief sql server monitoring ways.

1103

---

Do I need a report server to run reports in my application?

170

---

What are the diifferences between the ms sql server vs mysql?

1240

---