经典sql语句面试题

year salary

------------------

2000 1000

2001 2000

2002 3000

2003 4000

解：

select b.year,sum(a.salary)

from salary a,salary b

where a.year<=b.year

group by b.year

order by b.year;

在面试过程中多次碰到一道SQL查询的题目，查询A(ID,Name)表中第31至40条记录，ID作为主键可能是不是连续增长的列，完整的查询语句如下：

方法一：

select top 10 *

from A

where ID >(select max(ID) from (select top 30 ID from A order by

ID ) T) order by ID

方法二：

select top 10 *

from A

where ID not In (select top 30 ID from A order by ID)

order by ID