SQL随机选 择一条记录????????????

[dys_198102]

我想从附合条件的记录中随机选择一条,SQL应怎么写???
下边是我写的SQL,但不知道具体怎么写..高手指教
Select top N * from Hover_Products where PClass ='" + BCNews_Name + "' and Product_t='1' order by id desc

[shinlgienls]

Select top N * from Hover_Products where PClass ='" + BCNews_Name + "' and Product_t='1' order by NEWID()

[jiang_jiajia10]

Select top N * from Hover_Products where PClass ='" + BCNews_Name + "' and Product_t='1' order by newid()

这样？

[criedshy]

select top 1 * from 表名 order by newid()

[hyj12345678]

后面用 order by newid()就行了

[dys_198102]

Select top N * from Hover_Products where PClass ='Garden Fun' and Product_t='1' order by NEWID()
消息102，级别15，状态1，第1 行
'N' 附近有语法错误。我在查询中直接给值测试..不行.

[KidAn]

Select top 1 * from Hover_Products where PClass ='Garden Fun' and Product_t='1' order by NEWID()

[zhxhdean]

[Quote=引用 5 楼 dys_198102 的回复:]
Select top N * from Hover_Products where PClass ='Garden Fun' and Product_t='1' order by NEWID()
消息102，级别15，状态1，第1 行
'N' 附近有语法错误。我在查询中直接给值测试..不行.
[/Quote]
top 后面必须是数字，写N肯定会报错

[shinlgienls]

[Quote=引用 1 楼 guoyz_1 的回复:]
Select top N * from Hover_Products where PClass ='" + BCNews_Name + "' and Product_t='1' order by NEWID()
[/Quote]

你的N是不是变量， 放在查询分析器里面

应该写成

[Quote=引用 1 楼 guoyz_1 的回复:]
Select top 10 * from Hover_Products where PClass ='" + BCNews_Name + "' and Product_t='1' order by NEWID()
[/Quote]

[abcyzq]

[Quote=引用 5 楼 dys_198102 的回复:]
Select top N * from Hover_Products where PClass ='Garden Fun' and Product_t='1' order by NEWID()
消息102，级别15，状态1，第1 行
'N' 附近有语法错误。我在查询中直接给值测试..不行.
[/Quote]

把N换成数字，比如说1.

[chuxue1342]

Select top 1 * from Hover_Products where PClass ='Garden Fun' and Product_t='1' order by NEWID()
这条就没问题!

[CODE163]

`````

[vito_fh]

NEWID
创建 uniqueidentifier 类型的唯一值。

语法
NEWID ( )

返回类型
uniqueidentifier

[dayou123123]

[Quote=引用 8 楼 guoyz_1 的回复:]
引用 1 楼 guoyz_1 的回复:
Select top N * from Hover_Products where PClass ='" + BCNews_Name + "' and Product_t='1' order by NEWID()


你的N是不是变量， 放在查询分析器里面

应该写成

引用 1 楼 guoyz_1 的回复:
Select top 10 * from Hover_Products where PClass ='" + BCNews_Name + "' and Product_t='1' order by NEWID()
[/Quote]
是在不行
Select * from Hover_Products where PClass ='" + BCNews_Name + "' and Product_t='1'
再不行 就是 lz。。。。哼哼

[mengxj85]

[Quote=引用 1 楼 guoyz_1 的回复:]
Select top N * from Hover_Products where PClass ='" + BCNews_Name + "' and Product_t='1' order by NEWID()
[/Quote]
Mark NEWID()

[jin225]

把n改成数字行了