db2怎么取第一条数据

来源:百度知道 编辑:UC知道 时间:2024/06/27 10:17:57

C:\>db2 "select * from test.employee fetch first 1 rows only"

EMPNO FIRSTNME MIDINIT LASTNAME WORKDEPT PHONENO HIREDATE JOB
EDLEVEL SEX BIRTHDATE SALARY BONUS COMM
------ ------------ ------- --------------- -------- ------- ---------- --------
------- --- ---------- ----------- ----------- -----------
000010 CHRISTINE I HAAS A00 3978 1965-01-01 PRES
18 F 1933-08-24 52750.00 1000.00 4220.00

1 条记录已选择。

select * from table fetch first 1 rows only