Answer / sudha

select max(sal) from emp where sal <(select max(sal) from
emp);

Answer / pranav damele

All the above one works with Oracle; this one is for MYSQL

second highest :
mysql> select * from employee group by salary desc limit 1,1;

limit 1,1; first '1' means that bring cursor to the end of record and the next '1' means number of records to be printed after the cursor position.

third highest:
mysql> select * from employee group by salary desc limit 2,1;

limit 2,1; '2' means that bring cursor to the end of 2nd record and the next '1' means number of records to be printed after the cursor position.

Answer / mohamed hussain

select salary from
(select salary,Dense_RANK() over (Order by salary desc) as
Level from salary) TMP
where Level=@Level

Answer / esakki

select max(salary) from employee where salary not in (select
top 1 salary from employee order by salary desc )


change 1 to 2,3,4,......like that for 3rd max ,4th max
salary.....

Answer / prashanth

select max(sal) from employee where sal<(select max(sal)
from employee)

Answer / ashwini

select top 1 salary from emp where salary in (select top 2
salary from emp order by salary asc) order by salary desc

Answer / naveen r kumar

SELECT Max(salary) FROM TABLE
WHERE salary NOT IN (SELECT Max(salary) FROM TABLE);

Answer / jhansi

select max(sal) from emp where sal<any(select max(sal) from
emp)

Answer / sankar

select * from emp where sal=(select max(sal) from emp where
sal not in(select max(sal) from emp))

Answer / pramila

not only seceond highest . you can retrieve 2nd , 3rd.....
highest salary form this query

select min(Salary) from
(select distinct top 2 Salary from tblCategory order by
Salary desc) as tblCategory

Does sql full backup truncate logs?

0 Answers  

how is exception handling handled in mysql? : Sql dba

0 Answers  

How to display the current date in sql?

0 Answers  

what is the sql query to display current date? : Sql dba

1 Answers  

What is execution plan in sql?

0 Answers  

What is parameter substitution in sql?

0 Answers  

Table1: Col1 col2 1 2 10 3 4 89 5 6 Table:2 Col1 col2 3 2 9 5 4 7 6 87 With the help of table1 and table2 write a query to simulate the fallowing results. Output1: Col1 col2 1 2 2 3 3 4 4 5 5 6 Output2: Col1 col2 2 3 10 4 5 89 6 7 1.Write query for single row to multiple row using sql statements. Eg:a,b,c,d,e,f Change to A B C D E F 2. Write query for multiple row to single row using sql statements. Eg2 A B C D E F Change to Eg:a,b,c,d,e,f Table1: Col1 col2 8 5 2 9 4 2 5 1.Write a query to select all the rows from a table1,if the value of A is null then corresponding B’s value should be printed in A’s value.if the value of A is null in that table then corresponding B’s value should be printed as 30. 2. write a query to find the sum of A and B .display the max among both. 3.write a query to find total number of rows from table 1. Note: if any column value is null in a row then that row should be considered as 2 rows. 4.write a query to display all the records of table1 except A containg 2 as well B containg 5. 5.rewrite the fallowing without using join and group by. Select b.title,max(bc.returneddate –bc.checkoutdate)” mostdaysout” From bookshelf_checkout bc, Book shelf B Where bc.title(+)=b.title Group by b.title. 6.rewrite fallowing query Select id_category from category_master X where exists (select 1 from sub_category Y where X.id_category=Y.id_category) Customer: Name phone1 phone2 phone3 bitwise A 23456 67890 12345 --- B 67459 89760 37689 --- Don’t_call Col1 67890 37689 1.q) update the customer table of bitwise with 1 or 0. Exists in don’t_call table menas show -1 Other wise -0. Output. Name bitwise A 010 B 010

0 Answers   Protech,

What is the syntax and use of the coalesce function?

0 Answers  

How to recompile a already made trigger?

2 Answers  

can i call procedure in package

3 Answers   TCS,

What is the current version of sql?

0 Answers  

Is sql a microsoft product?

0 Answers