Answer Posted / mehul

for 2nd highest salary

select max(salary) from employee where salary<(select max
(salary) from employee )


for 2nd least salary

select min(salary) from employee where salary>(select min
(salary) from employee )

i hope that will help you

Difference between uniqe index and uniqe constraint?

1046

---

What is user defined datatypes and when you should go for them?

1073

---

What is usually the first word in a sql query?

1177

---

What are triggers? How do you invoke a trigger on demand?

1367

---

What is the difference between the application object and session object?

1124

---

How to create an inline table-valued function?

1023

---

What happens if ntwdblib.dll is missing on your machine?

1190

---

You want to implement the one-to-many relationship while designing tables. How would you do it?

998

---

What are secondary xml indexes?

1077

---

What are database states in ms sql server?

1247

---

You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

1062

---

How to write an inner join with the where clause in ms sql server?

1167

---

Can we use pragma autonomous_transaction in trigger?

1016

---

What is a coalesce function?

1254

---

What is the standby server?

1001

---