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

learnskills profile image

Amazon Redshift now supports refresh interval in a zero-ETL integration

Learn2Skills -

nozibul_islam_113b1d5334f profile image

Vector Search and Semantic Search in Depth

Nozibul Islam -

isaandreanme profile image

Filament Database Notification Sound

Isa Andrean -

candidosales profile image

Deploying Payload CMS to Fly.io

Cândido Sales Gomes -