Member Avatar for jck6288

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
  • 96 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by nav33n

Recommended Answers

All 5 Replies

Member Avatar for nav33n


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.

Member Avatar for jck6288

I'm gonna go head and say no.

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

Member Avatar for ShawnCplus

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.

Member Avatar for nav33n

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.