77家的会客2010

Tag: 字段联接 | 记录数: 1
一条SQL语句,字段联接
Weather:晴转多云,南风4-5级,(22~29)℃

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