问个union 和order by的问题

[tina09]

select '' as fldValue union select fldValue from frmKeyWord where fldType='分类名'
这样一个语句，目的是取出一组数据字典，然后加一个空值

数据字典还有一个排序列fldID

用语句怎么实现，空值在最前面，后面数据字典中的值按fldID排列

[卖水果的net]

select name from (
    select '' name , 0 object_id  
    union all
    select name, object_id from sys.objects 
) x 
order by object_id

[tina09]

引用 3 楼 wmxcn2000 的回复:

select name from (
    select '' name , 0 object_id  
    union all
    select name, object_id from sys.objects 
) x 
order by object_id

搞定，3Q

[中国风]

e.g.

SELECT ROW_NUMBER()OVER(ORDER BY RAND()) AS fldID,* FROM (select '' as fldValue union ALL SELECT fldValue from frmKeyWord where fldType='分类名') AS t

[tina09]

引用 1 楼 roy_88 的回复:

e.g.

SELECT ROW_NUMBER()OVER(ORDER BY RAND()) AS fldID,* FROM (select '' as fldValue union ALL SELECT fldValue from frmKeyWord where fldType='分类名') AS t

谢谢，不过我这个fldID是表frmKeyword的列，你这个是用rownumber代替了