top of page
Search

SQL Queries #3

  • Prasanta Paul (Quality Test Engineer)
  • Apr 30, 2018
  • 1 min read

SQL query to fetch project-wise count of employees sorted by project's count in descending order.

Query:-

"Select project, count(empid) EmpProjectCount from sal group by project orderby EmpProjectCount DESC/ASC"

The Table structure is discussed in SQL Query #1 or #2.

تعليقات

bottom of page