Interested to Buy Any Domain ? << Click Here >> for more details...
Query to get max and second max in oracle in one query ?
- 34 Answers
- 66532 Views
- CTS, Keane India Ltd, TCS, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / shashank yadav
Select Max(sal) from emp
where sal < any (select sal from emp);
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / assdads
five times tapping shift key helps to go woth out a mouse
by using number key.you can copy data in form by pressing
shift+insert.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / raghav
SELECT MAX(SAL)
FROM EMPLOY
WHERE SAL < ( SELECT MAX(SAL) FROM EMPLOY )
| Is This Answer Correct ? | 5 Yes | 4 No |
Answer / vaibhav
SELECT Sal
FROM (Select Sal from Emp_Salary order by Sal desc)
WHERE rownum < =2;
Above query will fetch two rows. First row is the max salary
and second row second max.
IF we only need to find second max, then
SELECT Min(Sal)
FROM (Select Sal from Emp_Salary order by Sal desc)
WHERE rownum < =2;
| Is This Answer Correct ? | 4 Yes | 3 No |
Answer / amit golia
SELECT min(sal) FROM(SELECT DISTINCT(sal) FROM emp ORDER
BY sal DESC) WHERE ROWNUM<=2;
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / kevin sharpless
-- This query wiil return any number of the n items by
using the max/decode statements
select max(decode(rnum,1,salary,null)) max1
,max(decode(rnum,2,salary,null)) max2
from (
select 1 grp_col
,salary
,row_number() over (order by salary asc) rnum
from (
select distinct salary
from emp
)
)
group by grp_col
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / haddy
select ename,salary from (select distinct(salary) from
employee order by salary desc) where rownum<=2
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / roopa
SELECT MAX(E1.sal), MAX(E2.sal)
FROM emp E1, (SELECT sal FROM emp
WHERE sal NOT IN ( SELECT MAX(sal) FROM emp)) E2
| Is This Answer Correct ? | 7 Yes | 7 No |
Answer / zyxw
for removing lines between word document and to get in a
paragarph manner
first do ctrl+h and then put ^p and leave replace with
empty.and go for
replace or replace all depending on the situation.
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / deepa
select salary from (select salary from table_name order by salary desc) where rownum<3;
| Is This Answer Correct ? | 1 Yes | 1 No |
Is rowid unique in oracle?
What are the extensions used by oracle reports?
Two triggers one is before insert and other is after insert are firing on a table.If 10 times you insert in a table.Then how many times before trigger and how many types after trigger will fire in pl/sql.
What is Library Cache in Oracle?
How many types of synonyms in Oracle?
How to get last row id?
What is SYSTEM tablespace and When is it Created?
What is meant by recursive hints ?
How translate command is different from replace?
Design database draw er diagram for a certain scenario ?
0 Answers Keane India Ltd, TATA,
What is the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN?
What is an Index ?
Oracle General 
