qq_35821283的博客

--检索单列数据select prod_name from Products;--检索多列数据select prod_name,prod_price,prod_id from Products--检索所有列select * from Products--DISTINCT关键字select distinct vend_id from Products--限制结果select top 5 prod_n...

--函数select vend_name,UPPER(vend_name) as vend_name_upcase from Vendors order by vend_name;select order_num from Orders where DATEPART(yy,order_date)=2012;--聚集函数--求平均select AVG(prod_price)as avg_price ...