Answer / velmurugan p

Select min(sal) from table_name where sal in(Select top 2 sal from table_name)

Answer / karthik.k

select max(salary) as second_highest from emp where salary
< (select max(salary) from emp)

Answer / pramod sharma

select f_name max(salary)from emp,dep
where salary<(select max(salary)from emp)

Answer / satish kumar

Select Top1 salary
from(select Distinct Top2 salary from employee order by salary DESC) a order by salary

Answer / rajkumar

SELECT * FROM TABLE WHERE columnName =
(SELECT MAX(column_name) FROM TABLE WHERE
column_name<(SELECT max(column_name) FROM TABLE))

Answer / mangesh pardhi

SELECT salary
FROM employee e
WHERE 2=(SELECT COUNT(DISTINCT salary)
FROM employees
WHERE e.salary<=salary)
--replace the number with 2,3,4 u wil find the that position
salary

Answer / kishan singh chilwal

SELECT MAX(sal)
FROM emp
WHERE sal <> (SELECT MAX(sal) FROM emp);

<> = not equal to
the SELECT statement in the WHERE clause will find the 1st max sal in the table
the 1st SELECT statement will find max sal in the table after excluding the first max sal

(ALTERNATE WAY)

SELECT MAX(sal)
FROM emp
WHERE sal not in (select max(sal) from emp );

Answer / syed hussain

select min(salary) from tbl_emp where salary in
(select top 4 salary from Tbl_emp order by salary desc)

Answer / hima

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

Answer / subahar

SELECT MAX(average) AS Expr1
FROM sp
WHERE (average NOT IN
(SELECT MAX(average) AS Expr1
FROM sp AS sp_1))

What is pivot query?

0 Answers  

what command is used to create a table by copying the structure of another table including constraints ?

6 Answers   CMC, eicc,

what is cursor. write example of it. What are the attributes of cursor.

0 Answers  

Can we use update in sql function?

0 Answers  

need to split a string into separate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.

2 Answers  

What is indexes?

0 Answers  

Does group by remove duplicates?

0 Answers  

Explain spool.

0 Answers  

four procedures is are there should i write their in a package

2 Answers  

How do I view stored procedures?

0 Answers  

What is memory optimized table?

0 Answers  

what are ddl statements in mysql? : Sql dba

0 Answers