oracle中如何只查询一条复合条件的记录,即查到一条记录就返回?

2025-03-06 21:59:24
推荐回答(1个)
回答1:

SQL SERVER
select top 1 * from xxx

ORACLE
select * from xxx where rownum <= 1

My SQL
select * from xxxx limit 1

DB2:
select * from xxx fetch first 1 rows only