Answer / krishna kishore

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

Answer / kiran

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

/

Answer / ramcharan tej

select max(emp-sal) from emp
where emp-sal <(select max(emp-sal) from emp).

Answer / anurag kumar rai

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

Answer / sachin verma

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

Answer / anil maurya

select top 1 rate from HumanResources.EmployeePayHistory
where rate<(select MAX(rate) as R from HumanResources.EmployeePayHistory)
order by rAte Desc

Answer / surendra sharma

select min(sal) from table_name where sal in

(SELECT top 2 sal FROM table_name order by sal desc)

Answer / yash goyal

Select Distinct salary
from employees e
where &no-1=(select count(distinct salary )
from employees
where E.salary < salary);

Answer / bharat g

select * from (select ename,sal,dense_rank() over (order by sal desc) ranking from emp) where ranking=2;

Answer / vinay

select max(sal) from emp where rownum = 2;

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,

how will u find statistics of a database objects?

2 Answers   iFlex,

Which is better cte or subquery?

0 Answers  

Why you are not able to create a table using select command,if it is having a LONG column? for eg:create table test as select * from test1 here test1 containg a column having LONG datatype...

1 Answers  

Types of indexes. What is the default key created when a primary key is created in a table ?

5 Answers   TCS,

What are packages in pl sql and also explain its advantages?

0 Answers  

How can you load microsoft excel data into oracle? : aql loader

0 Answers  

how do u call in & out parameters for stored procedures?

10 Answers   A1 Technology, TCS, Techicon,

What is the difference between joins?

0 Answers  

Differences between UNIQUE and DISTINCT in select statements

26 Answers   ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro,

using comand prompt how can import table data and table space with example

2 Answers  

What is sql performance tuning?

0 Answers