www.bersaty.com
摘要: 检索不同的行:select vend_idfrom products;/*返回不同的值*/select distinct vend_idfrom products;限制结果:limit/*limit 5 指示sql返回不多于5行*/select vend_id from products limit 5;/*指定要检索的开始行和行数*/select prod_name from products limit 5,5;检索排序:order by/*从小到大*/select prod_name from products order by prod_name;/*按多个列排序*/select p. 阅读全文
posted @ 2013-08-22 10:03 bersaty 阅读(228) 评论(0) 推荐(0) 编辑