Answer Posted / kunal gupta

These are the easiest and best queries and 100% tested.

1) 2nd highest salary


select top 1 sal from (Select top 2 sal from emp group by
sal order by sal desc) e order by sal


like wise you can find n highet salar(e.g 5th largest 6th
largest)

select top 1 sal from (Select top [n] sal from emp group by
sal order by sal desc) e order by sal


2) fetch all duplicated records from the table

e.g If table has three columns named 'col1', 'col2'
and 'col3'

select col1, col2, col3 from tbl group by col1, col2, col
having count(col1)>1

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

1320

---

How to provide values to user defined function parameters?

1001

---

Explain about service Broker functions?

1025

---

How do I partition a table in sql server?

1031

---

What is the standby server?

946

---

What is the difference between coalesce() & isnull()?

1122

---

In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

2003

---

What is difference between rownum and rowid?

892

---

what is a live lock? : Sql server database administration

951

---

Mention the different authentication modes in sql server.

1040

---

Explain the cursor lock types?

1043

---

Explain the Ways to improve the performance of a sql azure database?

84

---

What is the datatype of rowid?

913

---

What is wide table?

944

---

How to execute stored procedure and set temp table in sql server?

1030

---