Question 231372 in PostgreSQL Question posted in
The official documentation can be found here.

Postgresql – How to make a table with count of each category

I have a table with two columns. One is Name, other is Mark.
Mark can be low, mid or high. Under every name, i want count of high low and mid.
enter image description here

Tags:

2

Answers


  1. 0 
    SELECT name, mark, COUNT(*)
FROM your_table
GROUP BY name, mark
    Login or Signup to reply.
  2. 0

    Using sql?
    Select name, count(mark)
    FROM your_table
    GROUP by name, mark

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search