Firebird LIMIT — лимитировать запрос
Аналогом в Firebird для MySQL запроса
SELECT PCODE,HISTNUM,FULLNAME FROM CLIENTS ORDER BY PCODE DESC LIMIT 10
будет:
SELECT FIRST 10 SKIP 0 PCODE,HISTNUM,FULLNAME FROM CLIENTS ORDER BY PCODE DESC
или:
SELECT PCODE,HISTNUM,FULLNAME FROM CLIENTS ORDER BY PCODE DESC ROWS 10
SELECT PCODE,HISTNUM,FULLNAME FROM CLIENTS ORDER BY PCODE DESC ROWS 1 TO 10
Categories: Other
