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

domfive profile image

How to Create a Database Front End in 4 Steps

Dom | Five.Co -

adela_bytebase profile image

⚙️🔥 Automating Database Schema Change workflow Using GitHub Actions 🐙🚀

Adela -

sc0v0ne profile image

Tutorial: Install P3X Redis UI

sc0v0ne -

ftisiot profile image

List of PostgreSQL® AI Projects and Resources

Francesco Tisiot -