SQL 查询如何写

Question

我想随机从表中查询一条记录，SQL语句该如何写呢？

Answer 1

use tempdb
go
create table t1(col int)
go
declare @n int
set @n=0
while @n<10
begin
insert t1 (col) values(@n)
set @n=@n+1
end

 

select top 1 * from t1 order by  newid()

 

---

有dba的职位吗

Answer 2

ORDER BY NEWID()


--------------------------------------
成都有DBA职位

Answer 3

感谢各位的回答，如果在access中如何写呢？如何获取随机查询出的数据并删除这一行。

Answer 4

ACCESS:

select top 1 * from news order by rnd(id),delete from table where id=id


id为表的标识列

Answer 5

delete tablename where id in (select top 1 id from tablename)

Answer 6

select top 1 * from tablename order by rnd([一个自动编号字段])