求SQL语句

[呆呆辉]

我想把数据从表中全读出来,但其中某个特定的行(可能在数据库中间)我想提前到第一行输出来,该怎么写SQL?

[happyfamily]

select top 1 * from youTable

[happyfamily]

sorry
select top 1 * from youTable where yourColum = '特定字符'

[呆呆辉]

约速条件怎么写?比如我想把表全读出来,其中ID=5的行要提前到第一行来,怎么办?

[winehero]

select * from 表 where 条件 --条件就是取出这条记录的条件
UNION
select * from 表 where Not 条件

[winehero]

select * from 表 where ID=5
UNION
select * from 表 where ID<>5

[呆呆辉]

select top 1 * from youTable where yourColum = '特定字符'

只能读出yourColum = '特定字符'那行...其它行就读不出了啊

[happyfamily]

select top 1 * from youTable where yourColum = '特定字符'
union
select top 1 * from youTable where yourColum <> '特定字符'

[happyfamily]

select top 1 * from youTable where yourColum = '特定字符'
union
select * from youTable where yourColum <> '特定字符'

[windbey]

学习