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

What is the return type of executeupdate ()?

879

---

Explain candidate key, alternate key, and composite key?

964

---

Why do we use trigger?

939

---

What are trace files?

919

---

What does it mean to be in union?

897

---

How to view existing indexes on an given table using sys.indexes?

1064

---

How to execute multiple stored procedures at one time in sql server?

963

---

What are the steps you will take to improve the performance of a poor performing query?

951

---

What are the advantages of policy management?

963

---

Tell me something about security and sql azure?

114

---

What do you know about system database? : SQL Server Architecture

950

---

What is the difference between local and global temporary tables?

1099

---

What are database states in ms sql server?

1141

---

What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.

1227

---

Write a sql query to get zero records from a table having n number of records?

1150

---