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

stevendsanders profile image

Exploring Aurora DSQL with TypeScript, Drizzle, Lambda, and AWS CDK

Steve Sanders -

dm8ry profile image

Deploying a MongoDB Collection Generator on Kubernetes

Dmitry Romanoff -

aditi_b profile image

How to Install PostgreSQL on Ubuntu 22.04 LTS

Aditi Bindal -

anwaar profile image

SQL: ROW_NUMBER, RANK and DENSE_RANK

Anwar -