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

themodernpk profile image

How to FIX: Error: MySQL shutdown unexpectedly

Pradeep Kumar -

thadguidry profile image

How to connect and query multiple databases with a single REST API

Thad Guidry -

fernilo profile image

Transacciones en laravel

Fernilo -

mrcaption49 profile image

Dynamic SQL in PL/SQL

Pranav Bakare -