How to Write a Query to Get 4th Highest Salary for Each Department?
By: Sugandh | 14 Oct 2015 1:50 pm | 517 times viewed | 1 Comments
Could you guys please let me know that how to wirte a query to get 4th highest salary for each department?
kindly share your valuable views here, so i can proceed further.
Thanks in advance.
SAP Collaborates with Google Inc. for Enhanced Workflows in Both Companies.With complete focus on managing customer relations and business operations with the aid of the best technological inputs, SAP (Systems Applications and Products) serves as one of the best known and largest inter-enterprise software organization in the contemporary technology scene. It has a global...
Bill McDermott Recovering Well, To Continue As SAP's CEOSAP Chief Executive officer Bill McDermott is on a road to recovery though he may have suffered irreversible damage to his eye after the fall in July this year. Bill McDermott, 54 plans to be back in Germany hopefully by next month. As reported by German Magazine WirtschaftsWoche, McDermott...
SAP HR Interview Questions for ExperiencedWhich characteristics does a day with day type 1 have? Its OFF and PaidCan a posting run be deleted? Yes It can be reversed before the Bank transfer.Once the transfer is done the pay menets need to be adjusted in the next payments.What activities are possible when the payroll control record is...
SAP Does It Again, Acquires AribaSAP a well- known German company did it once again, for delivering the very best to all its partners and customers the company acquired Ariba in the year 2012! The company has acquired brands like Fieldglass, SuccessFactors, Hybris and Ariba. SAP aimed at rebranding all four of these brands. Going...
Query About SQL Plan Management?
Hello Experts,I have a query about sql plan management?Kindly share your valuable points for above requirment.Thanks in advance.
How to Get Size into a Temp Table and Check?
Hello Experts,I have a file in a shared folder. I need to run sql and get its size into a temp table and check whether any file had same size in past 10 hours.file is ofÂ IP extension. is there any...
How to Use Cursor in A Loop?
Hello Experts,I want use ref cursor in a loop. Does any one have any example of those?Actually my requirement is to calculate avg of time taken for the process at each 10 min time interval.Lets say...
I Need Query to Generate Email for Employees
This question asked in interview and even i don\'t know its possible or not.i need query to generate email for employees likeename starts with \'S\' then firstname.lastname@example.org starts with \'A\'...