Answer / abhishek jaiswal

select salary from employees a where &nth_highest_salary =(select count(distinct salary)
from employees b where a.salary<=b.salary)
/

Answer / mohammed irfan

SELECT sal1 "salary"
FROM (SELECT ROWNUM rownum1 ,sal1
FROM (SELECT sal sal1
FROM emp
ORDER BY sal DESC
)
)
WHERE rownum1=:p_highest;

Note:- 'p_highest' here we can give the number as we want
to display the highest salary.

Answer / ruma

select *from emp order by sal desc limit 1,1

Answer / hitesh pundir

select max(salary)from m1 where salary <>(select max(salary)
from m1)

Answer / vinay

It works gr8...

select max(salary) from <table_name> where salary<(select
max(salary)from <table_name>)

Answer / mallika

SELECT salary FROM employee a
WHERE &n IN (SELECT COUNT(*) FROM employee b
WHERE a.salary <= b.salary)

Answer / neeraj

SELECT DISTINCT(SAL) FROM EMP
WHERE SAL=(SELECT MIN(SAL) FROM (SELECT SAL FROM EMP ORDER
BY SAL DESC)
WHERE ROWNUM<=2);

Answer / sathiavathi

select max(salary) from employee where salary!=(select max
(salary) from employee);

Answer / sarojkant

select max(salary ) from emp table where sal<(select max
(salary)from emp table)

Answer / sarojkant

select sal from emp
where rownum=2
order by sal desc

What port does sql server use?

0 Answers  

What is bind reference and how can it be created?

0 Answers  

What is write ahead logging in sql server?

0 Answers  

sql query to get zero records from a table having n no of records

8 Answers   CTS,

how can we destroy the session, how can we unset the variable of a session? : Sql dba

0 Answers  

How many types of database triggers can be specified on a table ? What are they ?

2 Answers  

what is called after appearing where clause

3 Answers  

How many types of tables are there?

0 Answers  

what is the command for user data type?

2 Answers  

What are the types of SQL Statement?

3 Answers  

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

1 Answers  

What is a database? Explain

0 Answers