DEV Community

AsadullohRuziev
AsadullohRuziev

Posted on

PostgreSQL unit-9

#database #postgres #mysql #sql

Image description

SELECT DISTINCT country FROM users;
Enter fullscreen mode Exit fullscreen mode

Image description

SELECT country FROM users GROUP BY country;
Enter fullscreen mode Exit fullscreen mode

Image description

SELECT country, COUNT(*) FROM users GROUP BY country;
Enter fullscreen mode Exit fullscreen mode

Image description

SELECT country, COUNT(*) FROM users GROUP BY country HAVING COUNT(*) > 2;
Enter fullscreen mode Exit fullscreen mode

Image description

Top comments (0)

Read next

danielthomaschapman profile image

Minimising PostgreSQL RDS minor & major upgrade time with Blue/Green deployments

Daniel Chapman -

yukaty profile image

Part 2: Implementing Vector Search with OpenAI

yukaty -

maxx_ok profile image

Deploying a Rails API-Only App with Postgres using Kamal 2

Max Moreno -

shikha_gupta_080e904b317e profile image

Handling Data in SQL: Signed vs. Unsigned Types

Shikha Gupta -