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)

Why does sql studio use a single registered database repository? : sql server management studio

1040

---

Difference between group by clause and having clause in SQL?

1028

---

What are page splits? : SQL Server Architecture

1039

---

Define cursor locking

1061

---

If a table does not have a unique index, can a cursor be opened on it?

959

---

What are the restrictions while creating batches in sql server?

1116

---

Explain nested trigger in sql?

1131

---

role of sql sever 2005 in database rather than any other database

1990

---

How extra digits are handled with numeric data type literals?

1031

---

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

1031

---

Explain about extended stored procedure?

993

---

How to concatenate two binary strings together?

1175

---

what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

5976

---

Give an example of SQL injection attack ?

1052

---

What is report subscription?

132

---