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

monikaprajapati_70 profile image

Best Practices for dynamodb

Monika Prajapati -

burakboduroglu profile image

Prisma Part 1: Your Easy Tutorial to Set up Prisma

Burak Boduroğlu -

jao_dev profile image

Docker for beginners: Creating Database Containers

João Vitor -

devartteam profile image

Top Alternative to Navicat for Windows

Devart -