Mysql
SELECT * FROM iaggregator.tbl_message_order ORDER BY message_order_id DESC LIMIT 1,10

Oracle

SELECT * FROM (
SELECT * FROM (
SELECT * FROM iaggregator.tbl_message_order ORDER BY message_order_id DESC
)
)
WHERE rownum BETWEEN 1 AND 10

ket :
iaggregator = schema
tbl_message_order = table

Advertisement