Answer Posted / punit kumar

1.To find second highest salary

select max(sal) from emp_record
where sal not in (select max(sal)from emp_record)


2.To find second highest salary

select max(sal) from emp_record
where sal < (select max(sal)from emp_record)


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



by:-

PUNIT CHAUHAN

DELHI
MCA STUDENT STUDIS IN NOIDA

Define inner join in sql server joins?

1125

---

What is function of ROLLUP ?

1140

---

What is difference between index and primary key?

1138

---

Define model database?

1032

---

What is change data capture (cdc) feature?

1122

---

Do you know what are the steps to process a single select statement?

1018

---

What is the difference between the 2 operating modes of database mirroring?

1165

---

Explain how many normalization forms?

1077

---

How to create user messages with print statements in ms sql server?

1031

---

What do you understand by check constraint in sql server?

1018

---

What are the new data types are introduced in sql 2000?

949

---

What is sql server replication? : sql server replication

1039

---

Does table partitioning improve performance?

1015

---

What is truncate table?

1003

---

Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

1030

---