Answer / digvijay

select max(salary) from emp where salary < Top Salary

Answer / prem

SQL> select salary from(select salary,rownum a from(select salary from employee order by salary desc))where a=2;

Answer / souri sengupta

select max(salary) from employee where salary not in (select max(salary) from employee);


This worked :)

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);

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

Answer / mahendra

SELECT max(salary) FROM Employee WHERE salary NOT IN
(SELECT max(salary) FROM Employee);

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

Answer / new

select max(salary) from users where salary not in (select max(salary) from users)

Answer / elumalai d

SELECT * FROM (SELECT salary FROM emp ORDER BY salary DESC) WHERE ROWNUM<3;

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;

what are the database links ?

2 Answers  

How to start a new transaction in oracle?

0 Answers  

What is concurrency in oracle?

0 Answers  

What is catalog in Oracle?

0 Answers   MCN Solutions,

How to select oracle sequence from different schema and How to select oracle sequence from different Databases. Explain with example

1 Answers   Polaris,

How to add a new column to an existing table with a default value?

0 Answers  

Explain constraining triggers.

0 Answers  

How to load data from external tables to regular tables?

0 Answers  

I have two tables : COuntry,city I want all the cities in each country.Question on Cross Join.

3 Answers   Microsoft,

create or replace procedure show_tab_rec ( P_tab VARCHAR2 ) IS cmd varchar2(50); begin cmd := 'select * from '|| P_tab; for int in ( execute immediate cmd ) loop dbms_output.put_line ( int.ename||' '||int.deptno); end loop; end; when i m compling this procedure i m getting this error PLS-00103: Encountered the symbol "IMMEDIATE" when expecting one of the following: . ( ) , * @ % & | = - + < / > at in is mod remainder not range rem => .. <an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_ LIKE4_ LIKEC_ between || multiset member SUBMULTISET_ PLZ solve this error give this question answer asap Thanks advance.......

1 Answers   HCL,

What is the data type of dual table?

0 Answers  

What is E-R diagram ?

2 Answers   CGI, Keane India Ltd,