Answer / gaurav singh 'viccky'

select salary from user=(select max(salary)from user where
salary < (select max(salary)from user))

Answer / arjunraj

aa means table-alias name
bb means table-alisa name

select * from emp aa where 2=(select count(distinct empsalary) from emp bb where aa.empsalary<=bb.empsalary)

Answer / dakshin

select * from (select a.*,dense_rank() over (order by sal) rnk from emp a order by sal) where rnk =2

Answer / kishor dange

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

Answer / vikas

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

Answer / ashwini

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

Answer / manjusha

select * from emp e1
where 2=(select count(distinct salary) from emp e2
where e1.sal<e2.sal);

Answer / hari thorat

select max(salary) from employee where salary <(select max(salary) from employee);

Answer / gunjal ghagre

Select sal from table_name order by sal desc limit 1,1;

Answer / debasish

select ename,sal from (select ename,sal,row_number()
over(order by sal desc)rn from emp)
where rn=1;

How do you bind variables in pl sql?

0 Answers  

How do you get all records from 2 tables. Which join do you use?

8 Answers   Microsoft,

What is the difference between drop and truncate commands?

0 Answers  

Mention what plvcmt and plvrb does in pl/sql?

0 Answers  

Can procedure in package be overloaded?

0 Answers   EXL,

When can we use the where clause and the having clause?

0 Answers  

What is the best partition size for windows 10?

0 Answers  

What is the Difference between Procedure and Function.Can we call a Function in a DML?

2 Answers   TCS,

Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

0 Answers  

What is the largest value that can be stored in a byte data field?

0 Answers  

I have a tablle like this. cust acc --------------- a 1 b 2|3 c 4|5|6 I Want below o/p: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 Please any one can you have any ideas share me. I have urgent requirement.

4 Answers   Cap Gemini, MTS,

What are the parts of a basic sql query?

0 Answers