DEV Community

AsadullohRuziev
AsadullohRuziev

Posted on

PostgreSQL unit-7

Image description

 SELECT * FROM users LIMIT 10;
Enter fullscreen mode Exit fullscreen mode

Image description

 SELECT * FROM users OFFSET 15 LIMIT 10;
Enter fullscreen mode Exit fullscreen mode

Image description

SELECT * FROM users OFFSET 15 FETCH FIRST 10 ROW ONLY;
Enter fullscreen mode Exit fullscreen mode

Image description

Image description

 SELECT * FROM users WHERE  country='China' OR country='Russia' OR country='Sweden';
Enter fullscreen mode Exit fullscreen mode

and

SELECT * FROM users WHERE  country IN ('China','Russia','Sweden');
Enter fullscreen mode Exit fullscreen mode

Image description

Top comments (0)