Answer / senthil

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

Answer / srinivas

select * from emp m where(select count(distinct sal)+1 from emp s where s.sal>m.sal)=2

Answer / saiz

select min(salary)
from emp
where salary in ( select top 2 salary
from emp
order by salary desc);

What found sql?

0 Answers  

---

What is an implicit commit?

0 Answers  

---

Differences between UNIQUE and DISTINCT in select statements

26 Answers   ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro,

---

What are user defined stored procedures ?

3 Answers   BirlaSoft,

---

How do I count rows in sql query?

0 Answers  

---

How One can easily select all even, odd, or Nth rows from a table using SQL queries?

4 Answers  

---

Is a secondary key the same as a foreign key?

0 Answers  

---

I have one Excel file with 1,50,000 Records. Now I need to load that whole file into Oracle Database with same columns in Excel sheet . I need PLSQL Procedure or used by SQL PLUS

7 Answers   Polaris,

---

How do I run a script in sql developer?

0 Answers  

---

What is ttitle and btitle?

0 Answers  

---

How to return more than one value from a function?

11 Answers   Satyam,

---

What are the indexing methods?

0 Answers  

---