Answer / raj

for example if we take emp table:

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

Answer / debashis mohanty

Select Name,Deptno,Salary,Rank from
(
Select Ename Name,Deptno,Sal Salary,Rank () over(Order By Sal Desc) Rank from emp
)
Where Rank=4

Answer / nishi.swain@gmail.com

select distinct sal from table_name t1 where 4=(select count(distinct sal) from table_name t2 where
t1.sal<=t2.sal);

Answer / raj

for example if we take emp table, the query like this...
select a.sal from emp a where 4=(select count(distinct(b.sal))from emp b where a.sal<=b.sal)

Answer / sreeharibabu

SELECT id
FROM (select salary2.*, rownum rnum from
(select * from test ORDER BY id DESC) salary2
where rownum <=4)
WHERE rnum >= 4;

Answer / mujahid

Simple one is i think:
Select min(sal) from (select sal from emp order by sal desc LIMIT 4);

Answer / anand v

select user_name,sal,rank over(order by sal desc) rank from table
where rank =4

how will be date change into string

4 Answers  

How to maintain the history of code changes of pl/sql?

3 Answers  

HOW TO ADD PRIMARY KEY TO TABLE BY PL/SQL PROGRAM

3 Answers  

Does truncate need commit?

0 Answers  

What is the criteria while applying index to any column on any table.

1 Answers   Infogain,

which tcp/ip port does sql server run on? : Sql dba

0 Answers  

Is left join same as inner join?

0 Answers  

write a qurey for finding the length of the sting.

6 Answers   Infosys, TCS,

How many types of index are there?

0 Answers  

in table there r so many rows write a query which two rows r updated last two day befor?

3 Answers   Exilant,

i have a table like this. cityno cityname mails 1 BANGALORE 8KM 2 HSR LAYOUT 20KM 3 MEJISTIC 30KM 4 JAYADEVA 55KM 5 ITPL 80KM 6 HEBBAL 115KM I HAVE DATA LIKE THIS I WANT O/P LIKE THIS DISTANCE NO.OFCITY 0-50KM 3 51-100KM 2 101-150KM 4 AND SO ON pls give me answer. i want urgent

6 Answers  

What is before and after trigger?

0 Answers