Interested to Buy Any Domain ? << Click Here >> for more details...
hi friends please answer this question ASAP:-
how to count the no. of employee in a each department
or
no. of employee in each location by using emp/dept table
- 7 Answers
- 8072 Views
- Indecomm, I also Faced
- E-Mail Answers
Answer Posted / ezhumalai
select d.dept_ID ,count(empid) from Emp a inner join Department b
on a.empid=b.empid
group by d.dept_ID
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
Explain the types of indexes.
What are the different acid properties?
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
How do you improve the performance of a SQL Azure Database?
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
What do you do in data exploration
what are the critical issues you have resloved in your company
How to verify a user name with sqlcmd tool?
What is relationship? What number of sorts of relationship are there?
What is the sql profiler?
How each E-R model constructs can be mapped to the relational model?
explain different levels of normalization? : Sql server database administration
Explain the xml support sql server extends?
Can a trigger be created on a view?
