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

can we have a nested transaction? : Sql server database administration

991

---

How to create a dynamic cursor with the dynamic option?

968

---

What is difference between views and tables?

913

---

Explain what is analysis service repository?

925

---

How can I create a new template for import ? : sql server management studio

1022

---

hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

2156

---

What is an execution plan?

1056

---

Explain how to send email from sql database?

972

---

what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

967

---

What are the different types of backups that exist?

1108

---

what is raid and what are different types of raid configurations? : Sql server database administration

974

---

what are constraints? : Sql server database administration

981

---

How will you know when statistics on a table are obsolete?

1031

---

What is field with example?

868

---

Explain Capacity planning to create a database? and how to monitor it?

4140

---