Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


how to select second mauximum value in a given table under salary column

Answers were Sorted based on User's Feedback



how to select second mauximum value in a given table under salary column..

Answer / jai

SELECT MAX(SALARY) FROM EMPLOYEE
WHERE SALARY NOT IN(SELECT MAX(SALARY) FROM EMPLOYEE)

Is This Answer Correct ?    27 Yes 2 No

how to select second mauximum value in a given table under salary column..

Answer / sonthosh

SELECT * FROM
(
SELECT
NAME
,SALARY
,RANK() OVER (order by salary desc) RANK
FROM EMPLOYEE)
WHERE RANK = 2

Is This Answer Correct ?    7 Yes 4 No

how to select second mauximum value in a given table under salary column..

Answer / utkal

Select distinct(E1.Salary) from EMPLOYEE E1 where 2 =
(Select Count(distinct(E2.Salary)) from Employe E2 where
E1.Salary <= E2.Salary).

Here n=2,

Similarily we can find the 5th highest salary etc...

Is This Answer Correct ?    2 Yes 0 No

how to select second mauximum value in a given table under salary column..

Answer / u.radha

SELECT * FROM (SELECT ENAME,SAL,DENSE_RANK() OVER(ORDER BY SAL DESC) RN FROM EMP) WHERE RN = 2;

Is This Answer Correct ?    2 Yes 0 No

how to select second mauximum value in a given table under salary column..

Answer / shri

select min(sal) from (select * from emp order by sal desc) where rownum<3

IN Informatica also use the query in source qualifier's
"sql override". which will reduce d no. of t/r in d mapping

Is This Answer Correct ?    3 Yes 3 No

how to select second mauximum value in a given table under salary column..

Answer / ramesh

create table emp(sal number(5,2);

Is This Answer Correct ?    1 Yes 19 No

Post New Answer

More Oracle General Interview Questions

What is Rollback Segment ?

3 Answers  


Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

0 Answers  


Explain what are the uses of rollback segment?

0 Answers  


why you need store procedure ? where do we use it in a Java project? can you get the code for as store procedure using in Java?

1 Answers   Goldman Sachs,


find out the third highest salary?

92 Answers   CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon,


How do I find my oracle client driver version?

0 Answers  


How do I call oracle stored procedures that take no parameters?

0 Answers  


What is forall Statement ?

2 Answers   Thermotech,


How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

0 Answers  


What is recovery manager in Oracle?

0 Answers   MCN Solutions,


What is Library Cache in Oracle?

0 Answers   MCN Solutions,


How to synchronize 2 schema's objects?

0 Answers   Virtusa,


Categories
  • Oracle General Interview Questions Oracle General (1809)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)