Question

select * from product where juserid=10 and MemberPrice >0 order by memberprice desc 再加个范围查询

本人不是很懂SQL语句 谢谢

Answer 1

不懂你说的范围查询时什么意思，还有就是你使用的是什么数据库。建议下载sql教程，上面什么都有，对照着看看就行。

追问

SQL server 2005 急 between的那个

追答

BETWEEN 则是让我们可以运用一个范围 (range) 内抓出数据库中的值。BETWEEN这个子句的语法如下：
SELECT "栏位名" FROM " 表格名" WHERE "栏位名" BETWEEN '值一' AND '值二' 这将选出栏位值包含在值一及值二之间的每一笔资料。
例如：SELECT * FROM Store_Information WHERE Date BETWEEN 'Jan-06-1999' AND 'Jan-10-1999';
再例如：select * from product where juserid=10 and MemberPrice between 0 and 1000 order by MemberPrice desc

追问

select * from(select row_number() over(order by memberprice desc )as row_number,* from product where juserid=33 and MemberPrice >0) product where row_number between 1 and 16 我问错了 不好意思 已经解决了 谢谢