SQL语句

<pre><code>select top 5 * from products;--SQL Server显示指定行数 select * from products limit 5 ;--mysql 显示指定行数 select * from products limit 5 offset 5 ;--mysql 显示指定行数，从第五行开始 select cust_contact from customers where cust_contact like '[MJ]%' order by cust_contact;--sql server 集合匹配 select cust_contact from customers where cust_contact like '[^MJ]%' order by cust_contact;--非匹配集合 SELECT vend_name + '(' + vend_country + ')' FROM Vendors ORDER BY vend_name;--拼接用+号</code></pre>