Answer / jebitha

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

Answer / babbu

it's easy with self join:
select max(sal) from emp e1,emp e2 where e1.sal < e2.sal

Answer / lakshminarayana reddy

select rownum,empno,ename,job,sal from emp(select
rownum,empno,ename,job,sal from emp order by sal desc) grop
by rownum,empno,ename,job,sal having rownum=2;

Answer / varun

select max(sal) from emp ((select sal from emp)-(select max
(sal) from emp))

Answer / naresh kumar kalangi

select top 1 * from (select top 2 * from emp order by sal
desc)s order by sal

Answer / surajit pathak

select * from emp e1
where 2>(select count(1) from emp e2
where e2.sal>e1.sal)
order by sal desc

Answer / satya_k21

Hi,


Select * from emp e where 2>= (select count(sal) from
emp e where sal>=e.sal) order by desc.

Let me know if it is wrong..


Regards,
Satya.K

Answer / rajesh.m

Crete Table Curtest(Emp char(40),salary money)
------------------------------------------------
Select Min(Salary) from Curtest where Salary
in (select Top 2 Salary from Curtest)

--------------------------------------------------

Answer / varun

select sal from emp where rownum=2 order by sal desc;

Explain autonomous transaction.

0 Answers  

What is schema in sql example?

0 Answers  

What is an index in sql with example?

0 Answers  

Can we use join in subquery?

0 Answers  

What are different types of indexes?

0 Answers  

how would concatenate strings in mysql? : Sql dba

0 Answers  

Is sql considered coding?

0 Answers  

Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

0 Answers  

declare v_count number(8,3); v_sal scott.emp.sal%type := '&P_sal'; cursor cur_name is select sal from scott.emp where sal between (v_sal-100) and (v_sal +1000); begin v_count :=nvl(sql%rowcount ,0); if v_count = 0 then dbms_output.put_line('no records are fetch in the given sal range'); else dbms_output.put_line('There is/are '||to_char(v_count)|| ' salaries are selected in the given range '); end if; end; in the above programm .....for any sal range ....always it shows the following message.. no records are fetch in the given sal range please find the mistake and share with me...with thansk and regards..sarao....

3 Answers   Satyam,

How do you retrieve the last N records from a table?

10 Answers  

How can I speed up sql query?

0 Answers  

What are pl/sql packages?

0 Answers