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

Оставить комментарий