Interested to Buy Any Domain ? << Click Here >> for more details...
how to find out second largest value in the table
- 8 Answers
- 9778 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / irshad ahmad
Select max(price) from product where price
not in (select max(price) from product);
| Is This Answer Correct ? | 15 Yes | 3 No |
Answer / sandeep
select * from (select ename,sal,rank() over(order by sal desc) as ranks from emp)
where ranks=2;
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / karthik
select distinct sal from emp a where 2 = (select count
(distinct sal) from emp b where a.sal <= b.sal)
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / mk
select *from emp where sal=(select distinct(max(sal)) from
emp where sal <select max(sal) from emp )
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sudhakara reddy k
select max(sal) from emp where
sal<(select max(sal) from emp);
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / kamala k n
select * from (select ename,sal,rank() over(order by sal desc) as ranks from emp)
where ranks=2;
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / vishal
select * from (
select * from test where sal < (select max(sal) from test)
order by 2 desc)
where rownum =1
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / anandh
select * from emp where sal = (select max(sal) from emp where sal<>(select max(sal) from emp));
| Is This Answer Correct ? | 0 Yes | 1 No |
Explain the function of optimizer in oracle?
Hi can anyone tell me where are the dumps found of OCA certification.. Also the materials to be studied for the preparation.
master table and child table performances and comparisons in Oracle ?
how to get last monday of a month?
According to oracle specification VIEW is a object. OBJECT that means anything stored in the oracle database that has the physical existence.why VIEW doesn't take memory in oracle database, but it is treated as a object ?Please explain ?
What is the difference between primary key and unique key and foreign key in oracle?
Will you be able to store pictures in the database?explain.
How to convert raw data type into text in oracle? Explain
Can we connect to ORACLE db using Windows Authentication?
How to rename a column in an existing table?
How to add another datafile to a tablespace?
What are various constraints used in SQL?
Oracle General 
