Answer Posted / narendra soni

create table #a(rn varchar(30),salary int)
insert into #a values('a',10000)
insert into #a values('b',12000)
insert into #a values('c',15000)
insert into #a values('e',25000)
insert into #a values('d',22000)
insert into #a values('f',30000)
insert into #a values('h',35000)
insert into #a values('g',32000)
insert into #a values('i',32000)
select * from #a order by salary desc
Select * from #a a where 1=(select count(distinct b.salary)
from #a b where a.salary <=b.salary)
Select * from #a a where 2=(select count(distinct b.salary)
from #a b where a.salary <=b.salary)
Select * from #a a where 3=(select count(distinct b.salary)
from #a b where a.salary <=b.salary)
Select * from #a a where 4=(select count(distinct b.salary)
from #a b where a.salary <=b.salary)

What is a covering index?

921

---

What is an index in sql?

962

---

When is update_statistics command used?

998

---

List the different index configurations possible for a table?

884

---

Explain having clause and where clause?

992

---

Can you name a few encryption mechanisms in sql server?

893

---

What are different types of replication in sql server?

1036

---

What do you understand by recursive stored procedure?

875

---

What is difference between after and before?

985

---

Can you move the resources after pausing the node? : sql server database administration

1044

---

Write a program using SQL queries to find a unique entry in a table.

943

---

Do you know what is rank function?

1035

---

what information is maintained within the msdb database? : Sql server administration

915

---

How to check parameter value in stored procedure sql server?

915

---

How do I find the sql server version?

958

---