我现在想查询浏览记录在0到10内的所有记录,查询所有浏览记录的语句如下,其中time_count就是浏览次数:
select s.SUPPLIER_NAME,s.supplier_id,s.BOOK_NAME,d.book_id,count(d.book_id) as time_count
from bookview d, books s
select s.SUPPLIER_NAME,s.supplier_id,s.BOOK_NAME,d.book_id,count(d.book_id) as time_count
from bookview d, books s
select s.SUPPLIER_NAME,s.supplier_id,s.BOOK_NAME,d.book_id,count(d.book_id) as time_count
from bookview d, books s where rownum<11
select s.SUPPLIER_NAME,s.supplier_id,s.BOOK_NAME,d.book_id,count(d.book_id) as time_count
from bookview d, books s
where d.book_id=s.book_id
from bookview d, books s
where d.book_id=s.book_id) a where a.time_count < 11
from edo_t_bookview d, supplier_v_books s
where d.book_id=s.book_id
group by s.SUPPLIER_NAME,s.supplier_id,s.BOOK_NAME,d.book_id
order by time_count desc
from bookview d, books s
where s.book_id=d.book_id
group by s.SUPPLIER_NAME,s.supplier_id,s.BOOK_NAME,d.book_id having(count(d.book_id)<11)
from bookview d, books s
where s.book_id=d.book_id
group by s.SUPPLIER_NAME,s.supplier_id,s.BOOK_NAME having(count(d.book_id) <11)
select s.SUPPLIER_NAME,s.supplier_id,s.BOOK_NAME,d.book_id,count(d.book_id) as time_count
from bookview d, books s
where d.book_id=s.book_id
group by s.SUPPLIER_NAME,s.supplier_id,s.BOOK_NAME,d.book_id
havging (count(d.book_id) < 11)