Answer / neil

select * from (select sal,deptno from emp a where
sal in (select distinct(b.sal) from emp b
where a.deptno=b.deptno and rownum<4)
order by deptno,sal desc )
minus
select * from (select sal,deptno from emp a where
sal in (select distinct(b.sal) from emp b
where a.deptno=b.deptno and rownum<3)
order by deptno,sal desc )

Answer / praveenkumar

SELECT salary FROM EMPtable
WHERE salary NOT IN ( SELECT MAX(salary)
FROM EMPtable)
ORDER BY salary DESC
FETCH FIRST ROW ONLY
---
We have verified and its working
fine.

Answer / arun

select distinct (a.salary) from employees a
where &N = (select count (distinct(b.salary))
from employees b where a.salary <= b.salary);

Answer / manvar prajesh

select top 1 name,salary from emp where salary<(select
max(salary) from emp)order by salary desc

Answer / barochia dharmesh

You should use rank query with order by and give where your
search criteria.

Answer / vikas

select * from(select e.*,row_number() over (order by
e.salary desc)rn from Employee e)where rn between 1 and 2
order by rn

Answer / ankit khanijau

Select salary from emp
where MAX(Select salary from emp where salary != MAX(salary))

Answer / abir dutta

select min(empsal)
from (select * from sal order by empsal desc)
where rownum <=2

Answer / monika

Select salary from emp order by salary desc LIMIT 1,1;

Answer / bhoopendra vishwakarma

select salary max(salary) from emp limit1 offset1

Question: Below is the table city gender name delhi male a delhi female b mumbai male c mumbai female d delhi male e I want the o/p as follows: male female delhi 2 1 mumbai 1 1 Please help me in writing the query that can yield the o/p mentioned above?

2 Answers  

How can you load microsoft excel data into oracle? : aql loader

0 Answers  

What is the default value of CHAR type?

3 Answers   Bosch,

Explain what is sql*plus?

0 Answers  

Does sql support programming?

0 Answers  

what are all the common sql function? : Sql dba

0 Answers  

Explain the concept of normalization.

3 Answers  

Which are the different character-manipulation functions in sql?

0 Answers  

Show the cursor attributes of pl/sql.

0 Answers  

what is datawarehouse? : Sql dba

0 Answers  

How do I view stored procedures?

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,