I have a user table that contains username, password and status jobs. The user have a option to fills unemployed and employed in jobs field. My question how to make sql statement to count how many people that choose unemployed and employed. Then view the result for number of unemployed and employed.
nealz
0
Newbie Poster
Recommended Answers
Jump to PostUse a query that groups users by status and in the second column put their count. Try to form a query for this.
All 4 Replies
verruckt24
438
Posting Shark
nav33n
472
Purple hazed!
Team Colleague
Featured Poster
verruckt24
438
Posting Shark
nav33n
472
Purple hazed!
Team Colleague
Featured Poster
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.