IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

DB2 most frequently asked queries


IBM Mainframe Forums -> Mainframe Interview Questions
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
mainframemouli

New User


Joined: 01 Mar 2005
Posts: 52
Location: Mysore

PostPosted: Mon May 02, 2005 7:45 pm
Reply with quote

4. Display the most recently hired person Department wise.

9. Display the year in which most people joined the co.and the number of people who joined during that period.

10. Display the year during which most people join the co. with their names,dept. num. and avg. salary of their depts.

11. Update the details of King, add Smith's salary to King's and transfer king to the same dept. as that of Allen.

3. Select the names of employees who have number of subordinates.

4. List those employees who have atleast one person reporting to them.
7. List the employees hired in dec.


pls try to write queries for this
Back to top
View user's profile Send private message
badal

New User


Joined: 05 Sep 2004
Posts: 21

PostPosted: Mon Jun 06, 2005 8:36 pm
Reply with quote

Hi,
can u get me the table structure ? so that we can frame the queries.
thanks.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> Mainframe Interview Questions

 


Similar Topics
Topic Forum Replies
No new posts Index related queries DB2 5
No new posts Need help with below queries DB2 3
No new posts Running queries against OLTP Database DB2 3
No new posts Selective execution of a queries DB2 9
No new posts Re-write queries to minimize the effe... DB2 6
Search our Forums:

Back to Top