Buy Questpond's video subscriptions on
huge discount
.
Online: 2145
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 - Display the employee LAST_NAME, DEPARTMENT_ID and HIRE_DATE of employees hired between May 1st 2003 and March 30th 2005. Order the query in ascending order by HIRE_DATE
Posted by
Bandi
on 11/30/2013 | Category:
Others Interview questions
| Views: 2073 |
Points: 40
Post
|
Interview FAQs
|
Exclusive Questions
|
Interview Home
Answer:
SELECT LAST_NAME, DEPARTMENT_ID, HIRE_DATE
FROM EMPLOYEES
WHERE HIRE_DATE ‘2003-05-01’ AND ‘2005-03-30’
ORDER BY HIRE_DATE
Asked In:
Many Interviews |
Alert Moderator
Bookmark It
< Previous :
DB2 - Display the LAST_NAME and HIRE_DATE of every ...
Next > :
DB2 - Display the LAST_NAME concatenated with DEPA ...
Comments or Responses
Login to post response
More Interview Questions by Bandi
DB2 - Display the LAST_NAME concatenated with DEPARTMENT_ID, separated ...
which of the following function calculates the cumulative distribution ...
what is the output of SELECT CHOOSE (0, 1, 2, 3)?
what is the output of SELECT CHOOSE (0, 1, 2, 3)?
DECLARE @CurrentDate DATETIME = '2012/09/23 10:23PM'; SELECT ...
DB2 - FIND THE NEXT LEAP YEAR using single SELECT statement?
what is resource db in sql server 2008?
Which of the following function is used to compare current row value w ...
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 ...