how to get second highest salary from a employee table and
how get a 5th highest salary from a employee table by using
proc sql?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Programming Languages AllOther Interview Questions

write a query that returns one row for each department and the number of employees in that department. Given two tables EMPLOYEE and DEPARTMENT, where there can be multiple employees per department.

0 Answers   IBM,


What is dialog programming?

0 Answers  


In mainframe SDSF, Can we copy the list of jobs currently executing in SDSF in to a seperate DATASET...?

0 Answers   DST Global Solutions,


Is strus threadsafe or not?

1 Answers  


Any real time example of O2C process from taking order till creating invoice.

0 Answers  






Need guidewire related Documents(Interview Question/Tips/Best Practice/Dumps)

0 Answers  


why applet is introduced?

1 Answers  


Hey this is venkatesh.Please can any body tell me what is SFLNXTCHG?where we use this keyword?what perpuse we use this?Can you tell me in real time senario with example? And in 7 specification(RPG/400)what is the mandatory specification using programs?

0 Answers  


I've an application where i need to give access to all the features only to admin and only few features to normal users. Say Menu...i dont want all my menu items to be accessible to all the users only the admin people can see few all the features where as normal users can have access to limited menu items...how can i achieve this. Please note that my menu is not a database driven menu.

1 Answers   Tesco,


Please describe an example where you used object orientation in one of your programs.

0 Answers  


1. Write a program to create a sentence at runtime and count number of vowels in it ? 2. Write a program to get a string and to convert the 1st letter of it to uppercase ?

0 Answers   HTC,


What is the language used for Artificial Intelligence?

1 Answers  


Categories