Answer Posted / abhijt shinde

select MIN(salary) from Employees
where salary IN
(Select Top 3 salary from Employees order by salary desc)

Select Top 1 salary from Employees where salary
Not IN(select Top 1 salary from Employees order by salary Desc)
order by salary Desc

What is the file extension for sql database?

1007

---

Explain the difference between 'between' & 'and' operators in sql

1004

---

What are the two virtual tables available at the time of database trigger execution?

1223

---

What is a common use of group by in sql?

1051

---

What are the different parts of a package?

1115

---

What are expressions?

1017

---

Does sql support programming?

1076

---

what is the command used to fetch first 5 characters of the string? : Sql dba

1639

---

what is the difference between join and union? : Sql dba

1117

---

Does sql*plus also have a pl/sql engine?

1082

---

Difference between table function and pipelined function?

1028

---

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

1096

---

What is sql performance tuning?

924

---

How to look at the current sql*plus system settings?

1152

---

What are inner and outer joins examples of both?

965

---