Answer / nagarjuna.reddy

select max(sal) from emp where sal <> (select max(Sal) from
emp)

Answer / sandip

SELECT MAX(SAL) FROM EMPLOYEE WHERE SAL<(SELECT MAX(SAL)
FROM EMPLOYEE);

I don't think this will work correct me if i am
wrong.Correct one is-------

SELECT MAX(SAL) as SAL FROM EMPLOYEE WHERE SAL<(SELECT MAX(SAL)
FROM EMPLOYEE);

Answer / sandip

SELECT MAX(SAL) FROM EMPLOYEE WHERE SAL<(SELECT MAX(SAL)
FROM EMPLOYEE);

The correct one is.......

SELECT MAX(SAL) as SAL FROM EMPLOYEE WHERE SAL<(SELECT MAX(SAL)
FROM EMPLOYEE);

Answer / pramod majhi

select max(salary) from employees where salary<(select
max(salary) from employees);

Answer / srinivas

select max(salary) from Emp where salary<(select max(salary) from Emp)

Answer / sushma

SELECT * from
(SELECT * FROM emp ORDER BY sal DESC)
WHERE rownum <= 2
MINUS
SELECT * from
(SELECT * FROM emp ORDER BY sal DESC)
WHERE rownum < 2

Answer / debasish sinha

select ename,sal,deptno
from emp
where sal =
(
select max(sal)
from emp
where level=2
connect by prior sal>sal
group by level
)

Answer / veera

SELECT * FROM EMP A WHERE &N-1=(SELECT COUNT(DISTINCT SAL) FROM EMP B WHERE A.SAL<B.SAL) ORDER BY SAL

Pass Paramenter :2..it will give the 2nd maximum salary

Answer / lalit raghuvanshi

I got the solution:
Multiple Sql server queries to get second,third,fourth or nth highest/maximum salary from employee table
http://www.webcodeexpert.com/2014/08/sql-server-query-to-get.html

Answer / ashish jain

select Salary from
(
select salary,ROW_NUMBER() over (order by salary desc) as rownum from Emp group by salary) temp
where rownum=2

Note :It can be used to get any highest salary, just use where rownum=nth salary

I have one Excel file with 1,50,000 Records. Now I need to load that whole file into Oracle Database with same columns in Excel sheet . I need PLSQL Procedure or used by SQL PLUS

7 Answers   Polaris,

What is primary key sql?

0 Answers  

if we give update table_name set column_name= default. what will happen? its given in pl sql block.what will hapen?

5 Answers   iFlex,

What is localdb mssqllocaldb?

0 Answers  

What is sqlcommand?

0 Answers  

Explain the the delete statements in sql?

0 Answers  

What does 0 mean in sql?

0 Answers  

what is self-join? : Sql dba

0 Answers  

Table Student has 3 columns,Student_id,Student_Name & Course_Id. Table Course has 2 columns, Course_Id & Course_Name.Write a query to listdown all the Courses and number of student in each course.

10 Answers   TCS,

What is the maximum number of triggers, you can apply on a single table?

0 Answers  

What is difference between hql and native sql?

0 Answers  

what is meant by nl2br()? : Sql dba

0 Answers