sql 获取分组第一行数据

是oracle数据库是这样写：

select namec,medicinemodel,outlookc,memo2 from (select namec,medicinemodel,outlookc,memo2 from 表名 group by namec,medicinemodel,outlookc,memo2 order by BidPrice) where rownum = 1

这样就查出第一行的数据

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

EMPNO FIRSTNME MIDINIT LASTNAMEWORKDEPT PHONENO HIREDATE JOB

EDLEVEL SEX BIRTHDATE SALARY BONUS COMM

------ ------------ ------- --------------- -------- ------- ---------- --------

------- --- ---------- ----------- ----------- -----------

000010 CHRISTINEI HAASA00 39781965-01-01 PRES

18 F 1933-08-2452750.00 1000.00 4220.00

1 条记录已选择。

---