-2

create a query that will display total no of employee and no of employee that hired in 1995,96,97 from employee table..

my employee table have field like
emp_id name hire_date.

3
Contributors
5
Replies
6
Views
7 Years
Discussion Span
Last Post by nav33n
0


Do not post homework problems expecting a quick answer without showing any effort yourself.

Seems like you didn't read the member rules.
Ch, ch. Read more on count and group by clauses. After reading them, you will be able to solve this query yourself. :)

Good luck.

1

m not student.. m professional..and this is required for my proj..
dnt worry i solved it now...no need to waste ur time..

Evn f ur prfsnal u nd 2 shw efrt. <--- This is hard to read
Even if you're a professional you need to show effort before we help you.

0

m not student.. m professional..and this is required for my proj..
dnt worry i solved it now...no need to waste ur time..

Congrats on solving your problem. I am glad you learnt something new :)

If you post your answer, even others may get to learn something from this thread.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.