vishnu vardhan reddy

 Profile Answers by vishnu vardhan reddy Questions by vishnu vardhan reddy

• Sep 16th, 2008

select e.* from( select enmae,sal,   dense_rank()  over(partition by deptno           order by sal) ranksal from emp)e  where e.ra...

hiasat

 Profile Answers by hiasat Questions by hiasat

• Aug 4th, 2008

SELECT empno,ename,salFROM ( select empno,ename,sal from emp order by sal asc )WHERE rownum

Answer Question  Select Best Answer

display the 5th lowest sal from emp table using Correlated subquery

sampra

 Profile Answers by sampra Questions by sampra

• Mar 6th, 2012

Select * from Hello h where 5=(select count (distinct amt) from hello where h.amt>amt)

This will give the 5th record from lowest

srikanth.cherukupalli

 Profile Answers by srikanth.cherukupalli Questions by srikanth.cherukupalli

• Mar 1st, 2012

Select rank,salary from (select rownum as rank, salary from (select distinct(salary) from emp order by salary)) where rank=5;

Answer Question  Select Best Answer

display the second lowest salary from emp table without using min & all

Pendo

• Jul 17th, 2021

SELECT Top (1) Salary FROM Employee ORDER BY Salary

Code
 

satyam singh

• Apr 22nd, 2020

"HAVING" clause is required. It works with "GROUP BY" clause

Answer Question  Select Best Answer