Buy Questpond's video subscriptions on
huge discount
.
Online: 2056
Home
Articles
Interviews
Forums
For Beginners
Popular Questions
ITIL Career Advice
PMP Career Advice
Career Advices
Codes
Videos
ASP.NET
ASP.NET MVC
Android Intel XDK
Sql Server
AngularJS
Bootstrap
Backbone.JS
MongoDB
LESS (CSS)
jQuery
WPF
WWF
SSIS
LightSwitch
Tutorials
News
ASP.NET MVC
|
Be Interview Ready
|
Top Performers
|
DNF MVP
|
Top Posts
|
Winners
|
Subscribe
|
Catalogs
Welcome Guest !
Register
Login
Home
>
Interviews
>
Others
>
Loading ...
DB2 - Write a query to get the employee name who joined the company recently (newest employee)
Posted by
Bandi
on 11/30/2013 | Category:
Others Interview questions
| Views: 4521 |
Points: 40
Post
|
Interview FAQs
|
Exclusive Questions
|
Interview Home
Answer:
SELECT FIRST_NAME AS “Recently joined employeeS”
FROM (SELECT FIRST_NAME,
RANK() OVER( ORDER BY hire_date DESC) RNK FROM EMPLOYEES) WHERE RNK =1
Asked In:
Many Interviews |
Alert Moderator
Bookmark It
< Previous :
DB2 - Find the count of departments having average ...
Next > :
DB2 - Write a query to get the employee name who j ...
Comments or Responses
Login to post response
More Interview Questions by Bandi
DB2 - Write a query to get the employee name who joined the company re ...
DB2 - Display number of employees in each department, if the departmen ...
DB2 - Display minimum salary from each department
DB2 - Write a query to display employee name who gets highest salary
DB2 - Write down the syntax order & execution order of SELECT, FRO ...
DB2 - How FECH FIRST clause works. Give an example.
DB2 - Difference between DROP & TRUNCATE
DB2 - Display the average salaries of each DEPARTMENT_ID, include only ...
Latest Interview Questions
What will happen,if we compile below code public interface intf_per ...
In VB.Net Overloads keyword is used for which type? Public Over ...
What is the best example of Function Overloading?
What will happen,if we compile below function? private double sum(i ...
What will happen,if we compile below function:- private double sum( ...
What will happen,if we compile below function? private double sum(i ...
What are the points which fulfill Function Overloading?
Does Function Overloading depend on Return Type?
More ...