Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

DB2 most frequently asked queries

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
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    Post subject: DB2 most frequently asked queries
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    Post subject:
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    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Running queries against OLTP Database A_programmers DB2 3 Tue Jul 14, 2015 4:51 pm
No new posts Selective execution of a queries Delip DB2 9 Fri Jan 16, 2015 3:51 pm
No new posts Re-write queries to minimize the effe... Anil Khanna DB2 6 Mon Aug 04, 2014 1:49 pm
No new posts Interview Questions asked in IBM trushant.w Mainframe Interview Questions 3 Fri Apr 18, 2014 9:33 am
No new posts Running multiple queries in a PS file... nikhil_bansal04 JCL & VSAM 12 Wed Dec 18, 2013 12:06 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us