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

What suggestions would you give to include quality, as well as, the production capability into design?

0 Answers  


CSS corp interview process and placement papers

0 Answers   CSS Corp,


I want to prepare for PSU's bt i dont know how many PSU's are open for computer science students and what is the competition level for these. So if anybody knows this please guide me through this.

0 Answers  


Name a accredited or govt approved university which have 100% online engineering course

0 Answers  


What is ball bearing concept & its design.

0 Answers  


There are n points and each point enclose with x and y axis form a rectangle and find the point using a program which forms the smallest rectangle?

0 Answers  


how to cable size by Amp with example

0 Answers   Uniflex,


If it requires 8 men to build a wall in 10 days then what time will it take to build by 4 men?

2 Answers  


i made lan connections ,then how can i establish the network....with that connections only is the network is established ...tell me the procedure for giving the lan connection for some(10) pc's?

0 Answers  


nohup sort employees > list 2 > error out & what will happen?

0 Answers   IBM,


why we use conio.h in c programming?

0 Answers   TCS,


1 01 101 0101 10101

4 Answers  


Categories
  • Civil Engineering Interview Questions Civil Engineering (5086)
  • Mechanical Engineering Interview Questions Mechanical Engineering (4453)
  • Electrical Engineering Interview Questions Electrical Engineering (16638)
  • 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)