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

In table three columns with 1 milion records(here there is no sequence values) i want add one more column with sequence values from the first how it is posible?

4 Answers   Tech Soft,

what is global variable in pl/sql

1 Answers  

Explain two virtual tables available at the time of database trigger execution.

1 Answers  

Why do we create views in sql?

0 Answers  

how many ways we can we find the current date using mysql? : Sql dba

0 Answers  

What is sql keyword?

0 Answers  

What is sql scripting?

0 Answers  

Enlist the characteristics of pl/sql?

0 Answers  

what is the difference between blob and text? : Sql dba

0 Answers  

select sal from emp group by sal

3 Answers   TCS,

How to call DDL statements from pl/sql?

5 Answers  

What is pl sql commands?

0 Answers