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

How to create dbo table in sql server?

1007

---

What methods do you follow to protect from sql injection attack?

1075

---

What is temporary table in sql server? Why we use temp table?

994

---

What is the maximum number of index per table?

1121

---

What is the difference between lock, block and deadlock? : sql server database administration

1094

---

Why do we need normalization?

978

---

How can you list all the columns in a database?

972

---

What is merge?

1072

---

Explain about temporary stored procedure?

1099

---

Can you get second highest salary from the table?

1010

---

What are the differences between char and nchar in ms sql server?

1144

---

What are the advantages of mirroring?

1043

---

If we delete pack Spec what will be the status of pack Body ?

1524

---

What are user-defined functions (udfs) in sql server?

1051

---

When multiple after triggers are attached to sql table, how to control the order of execution?

1108

---