Just some tips I found useful

Sql

MSSQL / MySQL /

mssql

SELECT name FROM SYS.DATABASES; // get all databases in sqlserver

SELECT ..... ORDER BY <> [ASC|DESC] OFFSET <1> ROW FETCH FIRST 1 ROW ONLY ;// Iter on <1> to get one row each request

SELECT productName, description FROM ForgeRock ORDER BY productName ASC offset 1 row fetch first 1 row only; 
Last updated on Wednesday, May 6, 2020
Published on Wednesday, May 6, 2020