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


display the second highest salary department wise in
employee table



display the second highest salary department wise in employee table..

Answer / nagendra maddi

SELECT DISTINCT *
FROM (SELECT deptno, sal,
DENSE_RANK () OVER (PARTITION BY
deptno ORDER BY sal DESC)

RANK
FROM scott.emp)
WHERE RANK <= 2;

Is This Answer Correct ?    6 Yes 1 No

Post New Answer

More Engineering AllOther Interview Questions

int i=~0; uint j=(uint)i; j++; printf(“%d”,j); what is the use of "uint" int the above code

0 Answers   Microsoft,


Why do windmills never appear stationary?

0 Answers  


how to create user name stape by stape in cisco router {with command}

0 Answers  


out of fgets() and gets()which function is safe to use and why in c language?

1 Answers  


how to find number of possible trees in a given tree with n nodes?

1 Answers   TCS,


15. What is your Future Plans for the Company if Permanently Employed?

0 Answers   Siemens,


suppose it takes 100 ns to access page table and 20 ns to access associative memory. if the average access time is 28 nano seconds the corressponding hit rate is: a) 100% b) 90 % c) 80 % d) 70%

3 Answers   UGC NET,


In how many ways can you put numbers 1 to 9 without repeating in a 3*3 matrix,So that the total of elements in any row and column and diagonal is 15?

0 Answers   Amazon,


why B+tree usually prefer as on exis structure to a data file?

0 Answers  


how to convert postfix notation into prefix in data structures. please send me algo of taha

0 Answers  


What is OHNS Material and can anybody explain the Chemical & Physical Properties of Same. Which Technical Standard Book shows this Specification. Why can't we use En series instead of OHNS. Where it is specifically Used.

3 Answers   Advanced Bolting Solutions,


can any one send me the configuration of cisco 1841 router????/

0 Answers   ABC,


Categories
  • Civil Engineering Interview Questions Civil Engineering (5086)
  • Mechanical Engineering Interview Questions Mechanical Engineering (4456)
  • Electrical Engineering Interview Questions Electrical Engineering (16639)
  • Electronics Communications Interview Questions Electronics Communications (3918)
  • Chemical Engineering Interview Questions Chemical Engineering (1095)
  • Aeronautical Engineering Interview Questions Aeronautical Engineering (239)
  • Bio Engineering Interview Questions Bio Engineering (96)
  • Metallurgy Interview Questions Metallurgy (361)
  • Industrial Engineering Interview Questions Industrial Engineering (259)
  • Instrumentation Interview Questions Instrumentation (3014)
  • Automobile Engineering Interview Questions Automobile Engineering (332)
  • Mechatronics Engineering Interview Questions Mechatronics Engineering (97)
  • Marine Engineering Interview Questions Marine Engineering (124)
  • Power Plant Engineering Interview Questions Power Plant Engineering (172)
  • Textile Engineering Interview Questions Textile Engineering (575)
  • Production Engineering Interview Questions Production Engineering (25)
  • Satellite Systems Engineering Interview Questions Satellite Systems Engineering (106)
  • Engineering AllOther Interview Questions Engineering AllOther (1379)