Answer / radha sri seshu.kolla

select max(sal) from emp where level=2 connect by prior
sal>sal group by level;

Answer / shalina bajaj

select sal from emp a
where $number = (select count(distinct(sal))
from emp b
where a.sal <= b.sal);

Answer / prasanthi

select * from (select rownum r,a.* from (select distinct
sal from emp order by sal desc)a)where r=&i

sql>enter i value(enter manually) 2

Answer / prasanna

select A.* from employee A where 1=(select count(distinct
B.sal) from employee B where B.sal>A.sal)

Answer / ved

select sal from emp
where limit,1
order by sal desc

Answer / raghavendraprasad

select salary from emp e where &n-1=(select count(*) from
emp where salary>e.salary);

Answer / ramesh lavanuru

SELECT sal1 "salary"
FROM (SELECT ROWNUM rownum1 ,sal1
FROM (SELECT sal sal1
FROM emp
ORDER BY sal DESC
)
)
WHERE rownum1=:p_highest;

Note:- 'p_highest' here we can give the number as we want
to display the highest salary.

Answer / avinav

By using the rank function we can get the 2nd highest
salary from the emp table

Answer / pradeep

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

Answer / rameshwari

select ename,esal from
(select ename,esal from hsal
order by esal desc)
where rownum <=2;

what is bcp? When is it used?

0 Answers  

define sql

3 Answers   Zensar,

Write a query to find the employees from EMP table those who have joined in Monday. (there is a column as hiredate which is a date column i.e values are like 03-DEC-81)

5 Answers  

How does rowid help in running a query faster?

0 Answers  

using comand prompt how can import table data and table space with example

2 Answers  

What is difference between mysql and postgresql?

0 Answers  

Which sql statement is used to return only different values?

0 Answers  

What is rank () in sql?

0 Answers  

I am creating an index on Emp table Empno column,if u using this indexed column in ur SELECT stmt. where clause,then how do u know that yr index will be working or nor? Thanks Advance...

3 Answers  

Difference between table function and pipelined function?

0 Answers  

How can I get the number of records affected by a stored procedure?

0 Answers  

What is basic structure of pl sql?

0 Answers