Question

从数据库中读取字段值得问题

我从数据库中读取“tupian"这个字段的不为空的按时间倒序排列的前三个值，然后我再读取同一数据表中的排除已读取的三个的其他的值，sql语句该怎么写，写写

Answer 1

第一个
select top 3 * from tablename where tupian is not null order by [date]
第二个
select * from tablename where tupian is not null and id not in(select top 3 * from tablename where tupian is not null order by [date]) order by [date]

Answer 2

1)select top3 * from Table where not tupian is null order by time desc
2)select * from Table where id not in (select id from Table where not tupian is null order by time desc)