Interested to Buy Any Domain ? << Click Here >> for more details...
find out the second highest salary?
- 55 Answers
- 91309 Views
- Cognizant, Nucsoft, Oracle, TCS, Wondersoft, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / digvijay
select max(salary) from emp where salary < Top Salary
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / prem
SQL> select salary from(select salary,rownum a from(select salary from employee order by salary desc))where a=2;
| Is This Answer Correct ? | 0 Yes | 0 No |
select max(salary) from employee where salary not in (select max(salary) from employee);
This worked :)
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sujeet sinha
SELECT DISTINCT (a.sal) FROM EMP A WHERE 2 = (SELECT COUNT
(DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal);
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / mukesh
Second highest Value
select max(user_id) from users
where user_id < (select max (user_id) from users)
Mukesh Narayan SIngh
09873595976
mukeshnsingh22@gmail.com
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / mahendra
SELECT max(salary) FROM Employee WHERE salary NOT IN
(SELECT max(salary) FROM Employee);
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / asit kumar sahu
SELECT DISTINCT SAL FROM EMP E1
WHERE 2=(SELECT COUNT(DISTINCT SAL) FROM EMP E2
WHERE E1.SAL <= E2.SAL);
OUTPUT= 3000
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / new
select max(salary) from users where salary not in (select max(salary) from users)
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / elumalai d
SELECT * FROM (SELECT salary FROM emp ORDER BY salary DESC) WHERE ROWNUM<3;
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / elumalai d
CREATE TABLE emp(ID NUMBER(10),NAME VARCHAR2(100),salary NUMBER(10));
INSERT INTO emp VALUES(100,'Steven',40000);
INSERT INTO emp VALUES(101,'Smith',30000);
INSERT INTO emp VALUES(102,'Ranshow',70000);
INSERT INTO emp VALUES(103,'Handscomp',20000);
INSERT INTO emp VALUES(104,'Mitchel',10000);
INSERT INTO emp VALUES(105,'Clarke',90000);
INSERT INTO emp VALUES(106,'Ponting',50000);
INSERT INTO emp VALUES(107,'Clarke',80000);
INSERT INTO emp VALUES(108,'Marsh',60000);
COMMIT;
SELECT salary FROM emp ORDER BY salary DESC;
--Records
--======
90000
80000
70000
60000
50000
40000
30000
20000
10000
SELECT min(salary) FROM (SELECT salary FROM emp ORDER BY salary DESC) WHERE ROWNUM<3;
| Is This Answer Correct ? | 0 Yes | 0 No |
What is blob datatype?
How to display row numbers with the records?
How to check your oracle database 10g xe installation?
what are the database links ?
What is a nested table and how is it different from a normal table?
We have one Package(which has many function/procedures, SQL quires etc). Now we need to check, which query or procedure is taking lot of time in that Package. ? How do we do it.
What would you do with an in-doubt distributed transaction?
How to create a testing table in oracle?
What are the different approaches used by Optimizer in choosing an execution plan ?
What is oracle join syntax?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
what is the exact diiference between DBMS and RDBMS
Oracle General 
