/SQL/Sql offset

Sql offset

Sql offset

SELECT * FROM "USER"
ORDER BY id_USER ASC OFFSET 9 limit 11; /*will get 10º to 20º row*/

4

Sql offfset

SELECT column_list
FROM   table1
ORDER BY column_list
LIMIT row_count OFFSET offset;

0

Source: sqltutorial.org

Similar codes

3 votes176 views2 answers
Create schema postgres
SQL
0 vote165 views1 answer
Select other columns with distinct
SQL
2 votes214 views2 answers
Mysql search for column name in all tables
SQL
0 vote230 views1 answer
Oracle sqlp update amount / quantity
SQL
0 vote169 views1 answer
Yesql
SQL
0 vote160 views1 answer
Oracle select invalid views
SQL
0 vote213 views1 answer
How to pass list as parameter in SQL query
SQL
0 vote173 views1 answer
Oracle merge insert if not exists
SQL
0 vote174 views1 answer
Look at running processes redshift
SQL
0 vote186 views1 answer
Convert int to varchar sql
SQL

Share