Results 1 to 5 of 5

Thread: How to display following matrix?

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 03-07-2007 #1
    orlando
    orlando is offline
    Junior Member
    Join Date
    Feb 2007
    Answers
    6

    How to display following matrix?

    Need to create a query to display the total number of employees and the number of employees hired in 1995, 1996, 1997 and 1998. i have difficulty of creating following format. not sure how to use group by clause
    Total | 1995 | 1996 | 1997 | 1998
    20 | 1 | 2 | 2 | 3

    Thank you,
    Orlando

    Last edited by orlando; 03-08-2007 at 06:30 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
GeekInterview
Interact