Posts
 
Reputation
Joined
Last Seen
Strength to Increase Rep
+0
Strength to Decrease Rep
-0
0% Quality Score
Upvotes Received
0
Posts with Upvotes
0
Upvoting Members
0
Downvotes Received
3
Posts with Downvotes
3
Downvoting Members
1
3 Commented Posts
0 Endorsements
Ranked #54.9K
~253 People Reached
Favorite Forums
Favorite Tags
Member Avatar for manoj201jain

Hi, I want to display the department no. and the no. of employee in each department from EMP Table.(in a Single Row). Pls help me how to write the query for that. I had one query which display the result in 3 rows. select deptno, count(*) from emp group by …

Member Avatar for Niteshkmr049
0
253