Question

请高手帮忙写个查询两张表的sql语句，并且只查询20条记录。

还有就是select top 20 *from book order by read desc 问什么查询出来的是表中的全部记录？

Answer 1

select top(20) a.*,b.* from a,b

Answer 2

连接查询用 join···on
比如查a表的A字段和b表的B字段，假设a表和b表有相同字段C
select top 20 A,B
from a join b on a.C=b.C

Answer 3

select a.* from a,b where a,id=b.id and rownum between 1 and 20

Answer 4

select a.* from a,b where a.id=b.id and rownum<21

Answer 5

kk表和mm表，相同字段myid
select a.* from kk a,mm b where a.myid=b.myid