Select (SQL): Difference between revisions

Revision as of 01:33, 15 December 2021

Revision as of 21:20, 20 March 2022

Line 347:

| <syntaxhighlight lang="sql" highlight="2">SELECT * FROM T

WHERE ID_T > 10 FETCH FIRST 10 ROWS ONLY</syntaxhighlight>

| [[IBM DB2|DB2Db2]]

|-

| <syntaxhighlight lang="sql" highlight="2">SELECT * FROM T

WHERE ID_T > 20 FETCH FIRST 10 ROWS ONLY</syntaxhighlight>

| [[IBM DB2|DB2Db2]] (new rows are filtered after comparing with key column of table T)

|}