1)、查找authors表的第七条记录:
SELECT * FROM authors order by au_id
select top 1 * from authors where au_id not in (select top 6 au_id from authors order by au_id)
2)、在 DELETE 和 SELECT 中使用 TOP 子句
3)、更新
update employee set job_id = job_id+1 where emp_id in (SELECT top 1 emp_id FROM employee order by emp_id)
SELECT * FROM authors order by au_id
select top 1 * from authors where au_id not in (select top 6 au_id from authors order by au_id)
2)、在 DELETE 和 SELECT 中使用 TOP 子句
由于可以在 DELETE 语句中指定 SELECT 语句,因此还可以在 SELECT 语句中使用 TOP 子句。例如,下例从 authors 表中删除前 10 个作者。
DELETE authors
FROM (SELECT TOP 10 * FROM authors) AS t1
WHERE authors.au_id = t1.au_id
3)、更新
update employee set job_id = job_id+1 where emp_id in (SELECT top 1 emp_id FROM employee order by emp_id)