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

Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

2101

---

What is data types in sql?

982

---

How do you run a query?

979

---

Does truncate remove indexes?

1008

---

How does index help in query performance?

1013

---

What is a variable in sql?

980

---

What is a table partition?

1105

---

What is sqlexception in java?

966

---

What does (*) mean in sql?

937

---

What is the difference between the conventional and direct path loader? : aql loader

1141

---

how can we repair a mysql table? : Sql dba

956

---

What is pl sql script?

1010

---

Is sql a backend language?

1073

---

What is record in pl sql?

1059

---

what is self join and what is the requirement of self join? : Sql dba

1120

---