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 happens if null values are involved in expressions? : Sql dba

0 Answers  

Does oracle use sql?

0 Answers  

What are two statement types in sql?

0 Answers  

What is procedure function?

0 Answers  

How does cross join work?

0 Answers  

how to see the create table statement of an existing table? : Sql dba

0 Answers  

I want to display the employees who have joined in last two months. (It should be executed randomly means If I execute the query in March it should display Jan and Feb joined employees. Same query if i execute in Feb, 2007 it should display dec, 2006 and jan 2007 joined employees.

15 Answers   Wipro,

Does indexing improve query performance?

1 Answers  

Explain the difference between sql and mysql.

0 Answers  

Name some usages of database trigger?

0 Answers  

Can you select everything, but 1 or 2 fields, without writer's cramp?

0 Answers  

what does the t-sql command ident_current does? : Transact sql

0 Answers