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

Write a Java program that takes an integer from the user and extracts and displays each digit of the integer in English. So, if the user types in 932, the program will display nine three two. [Use SimpleInput class]

0 Answers  


what is the best part of your life ?

1 Answers  


What do you think determines a person's progress in a good company?

0 Answers  


I found that there is no display on monitor even after the cpu have done its booting succesfuly....VGA port is normal and RAM was also been checked. What may the problem...please guide..thanks.

1 Answers  


Can you get the name of the data file used as Infile in the control file used for sql loader, and store it in a column of a table if the name of the data files are in a particular fashion and it is getting picked up one by one for loading the data using the command "Infile *"

0 Answers   Infosys,


when will the group1&group2 exams will be held

0 Answers  


four jobs j1,j2,j3 and j4 are waiting to be run. Their expected runtimes are 9,6,3 and 5 respectively. In order to minimize average response time, the jobs should be run in the order: a) j1j2j3j4 b)j4j3j2j1 c)j3j4j1j2 d)j3j4j2j1

2 Answers   TCS, UGC NET,


How do aeroplanes fly? Why can some fly up-side down?

0 Answers  


Hi I am Krushna.I have already applied for PO post in Syndicate Bank.Can anybody send me the sample paper for Syndicate bank PO.

0 Answers  


i have passed my gRaduation in BCA and now im looking for post graduation from Germany, i haver passed my ielts wth 6 band, nw plz tell me some question that wll ambessay ask

0 Answers  


If you have two 132KV distance scheme and you are using fibre for comms but the two relays on are not compatible interms of comms what can you use to allow communication between the two relays.

0 Answers   Eskom,


I need a last 3 years question paper for RRB exam,post of section engineer(computer science)

1 Answers   RRB,


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)