日归档:
2008年07月22日
| 记录数: 1
-
- 一条SQL语句,字段联接
- Weather:晴转多云,南风4－5级,(22～29)℃
- 2008-07-22
select spnumber || '-' || scNumber from dba.ast_scNumber where datediff(day,recTime,'2008/7/5')=0
再补一个
DB2中对应的select top n在DB2中对应的语法是select * from tablea fetch first n row only--取last n就 order by id desc- Views(5530) | Comments(2) | In web develop
