PostgreSQL unit-7

 SELECT * FROM users LIMIT 10;

 SELECT * FROM users OFFSET 15 LIMIT 10;

SELECT * FROM users OFFSET 15 FETCH FIRST 10 ROW ONLY;

 SELECT * FROM users WHERE  country='China' OR country='Russia' OR country='Sweden';

and

SELECT * FROM users WHERE  country IN ('China','Russia','Sweden');