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