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)

explain different levels of normalization? : Sql server database administration

1004

---

Can we delete data from a view?

924

---

Where is my database stored on the hard disk in ms sql server?

1060

---

How to connect php with different port numbers?

1085

---

What is the user of Primary key?

985

---

Explain go command in sql server?

1036

---

can you instantiate a com object by using t-sql? : Sql server database administration

1000

---

Explain data warehousing in sql server?

1048

---

Difference between Inner vs outer joins?

949

---

what is the difference between Delete and Truncate command in SQL

1147

---

Why truncate is ddl command?

1065

---

Explain try...catch with sql server?

1021

---

How to enter unicode character string literals in ms sql server?

1075

---

What is the sql case statement used for?

1098

---

Explain primary key, foreign key and unique key?

993

---