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

spwoodcock profile image

FastAPI, Pydantic, Psycopg3: the holy trinity for Python web APIs

Sam -

dm8ry profile image

Load Testing PostgreSQL on Kubernetes: A YAML-Only Approach

Dmitry Romanoff -

xxzeroxx profile image

MySQL Terminal: Alter table, charset and delete

Antonio Silva -

chijioke_osadebe_c6d2e7f7 profile image

FilmGuru: Your AI-Powered Movie Companion 🎬

Chijioke Osadebe -