1.Oracle中查询数据库表的第一条数据
SELECT * FROM (SELECT * FROM "user" ORDER BY "id") WHERE ROWNUM = 1
2.Oracle中查询数据库表的最后一条数据
SELECT * FROM (SELECT * FROM "user" ORDER BY "id" DESC) WHERE ROWNUM = 1
1.Oracle中查询数据库表的第一条数据
SELECT * FROM (SELECT * FROM "user" ORDER BY "id") WHERE ROWNUM = 1
2.Oracle中查询数据库表的最后一条数据
SELECT * FROM (SELECT * FROM "user" ORDER BY "id" DESC) WHERE ROWNUM = 1