DEV Community

AsadullohRuziev
AsadullohRuziev

Posted on

PostgresSQL unit-6

#postgres #database #sql #mysql 
SELECT DISTINCT country FROM users ORDER BY country;
Enter fullscreen mode Exit fullscreen mode

Image description

SELECT * FROM users WHERE gender='Female';
Enter fullscreen mode Exit fullscreen mode

Image description

SELECT * FROM users WHERE gender='Female' AND country='China';
Enter fullscreen mode Exit fullscreen mode

Image description

SELECT * FROM users WHERE gender='Female' AND (country='China' OR country='Russia');
Enter fullscreen mode Exit fullscreen mode

Image description

Top comments (0)

Read next

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 -

adityabhuyan profile image

Best Practices for Handling Sensitive Data in MySQL Databases

Aditya Pratap Bhuyan -

dm8ry profile image

Populating a Vertica Database with Random Data

Dmitry Romanoff -