怎么查询数据库中id在5——8之间的数据? 怎么查询数据库中id在5——8之间的数据?查询语句怎么写? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select * from tablename where id>=5 and id<=8 where id between 5 and 8 select * from tablename where id between 5 and 8 select * from table where id>=5 and id<=8; select * from tablename where id between 5 and 8或者select * from tablename where id>=5 and id<9 不是这样吧,用between不行用id>=5 and id <9更不行 呵呵~~是哦啊 原来是这样~~将查询出的结果排序可以使用这种方法:select * from(select * from tablename where id between 5 and 8) as t1 order by id desc; 用两个select 嵌套使用............... select * from (select top 4 * from (select top 8 * from 表 order by id desc) as t order by id )as t1 order by id desc select * from (select top 4 * from (select top 8 * from 表 order by id desc) as t order by id )as t1 order by id desc select top 4 * from tablename where id not in (select top 4 * from tablename) c# datagridview 底部合计 初学者求解答···急急急 关于弹出窗口的问题 RichTextBox控件怎么不能我鼠标拖拽选取啊 请问可以将下面的一串HTML源文件串成一个字符串吗? VB的DateSerial函数 在C#里面是什么?急。。在线等。 VS.Net用户的技术交流群号10370288 今天割除眼部霰粒肿,痛疼.... 求TWAIN中文版规范 新人求教如何用c#语言编写一个串口读写程序 string 类型转换成int碰到奇怪问题,请大家帮忙解决下 谢谢。 Calendar 控件的使用
select * from tablename where id>=5 and id<=8
或者
select * from tablename where id>=5 and id<9
原来是这样~~将查询出的结果排序可以使用这种方法:
select * from(select * from tablename where id between 5 and 8) as t1 order by id desc;
(select top 4 * from
(select top 8 * from 表 order by id desc)
as t order by id
)
as t1 order by id desc
(select top 4 * from
(select top 8 * from 表 order by id desc)
as t order by id
)
as t1 order by id desc