王朝知道

分享

 

01.能否告诉我,如我要查询表最后三项是这样的命令吗?select top 3 name from mytable order by desc
order by 后要加列名,我说哪个：lirong1978 - 高级经理 六级,人家不问你6级的分哪来得?跟这得便宜卖乖...查看完整版>>能否告诉我,如我要查询表最后三项是这样的命令吗?select top 3 name from mytable order by desc02.这句什么意思select top 8 * from news ORDER BY id DESC
按id降序顺序取出最上面的8条记录（例如，共有100条记录，则取出id为100，99，98，97，96，95，94，93的记录）...查看完整版>>这句什么意思select top 8 * from news ORDER BY id DESC03.sql = "SELECT * FROM message order by ID DESC"
按照ID字段降序排序。如果不写便是升序。...查看完整版>>sql = "SELECT * FROM message order by ID DESC"04.查询语句这样写SELECT top 4 * FROM article order by time desc怎么会是查整个表的记录？
加关键字distinct啊...查看完整版>>查询语句这样写SELECT top 4 * FROM article order by time desc怎么会是查整个表的记录？05.select * from user where part="&test "order by id desc
select * from user where part = (select part from user where id="&Session("Uid")) order by id desc这样可以用一句，自己调一下吧...查看完整版>>select * from user where part="&test "order by id desc06.sql="select * from wz order by id desc" | 无法理解？
从wz表中输出所有记录，按照id字段的降序排列...查看完整版>>sql="select * from wz order by id desc" | 无法理解？07.sql="select * from products where [type]=" & type_id & " order by id desc"
sql="select * from products where ="&type_id&" and<>105 order by id desc"注意and前应该有个空格...查看完整版>>sql="select * from products where [type]=" & type_id & " order by id desc"08.select top 6 * from Favorites where USR_ID="&rs2("id")&" 我要查询这个表里的不重复记录怎样做呀，
select top 6 distinct * from Favorites where USR_ID="&rs2("id")&""...查看完整版>>select top 6 * from Favorites where USR_ID="&rs2("id")&" 我要查询这个表里的不重复记录怎样做呀，09."select top 4 * from yl_product where id<(select max(id) form yl_product) order by id desc"
from 不是 formselect top 4 * from yl_product where id not in (select max(id) from yl_product) order by id desc...查看完整版>>"select top 4 * from yl_product where id<(select max(id) form yl_product) order by id desc"10.sql="SELECT top 1 * FROM chanpin ORDER BY id DESC"
是选取排序后的第一条记录。我估计是你两个页面的提交顺序不一样。出现你那种情况。自己再找找原因。 参考资料：...查看完整版>>sql="SELECT top 1 * FROM chanpin ORDER BY id DESC"

 

 

免责声明：本文为网络用户发布，其观点仅代表作者个人观点，与本站无关，本站仅提供信息存储服务。文中陈述内容未经本站证实，其真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。