单表查询

select * from Customers---显示所有消费者的所有信息--------

-----显示消费者的特定信息--------

select c_ID,c_Name,c_TrueName,c_Password from Customers

select c_ID,c_Name,c_TrueName,c_Password, year(getdate())-year(c_birth) from Customers

select c_ID as '会员编号',c_Name as '用户名',c_TrueName as '真实姓名', c_Password as '密码',year(getdate())-year(c_birth) as '年龄' from Customers

select * from Customers where c_Type='VIP'

select c_ID as '编号',c_Name as '姓名',c_birth as '出生日期', c_address as '籍贯',c_phone as '联系电话',c_email as '地址' from Customers where c_Type='VIP'

select * from Customers where c_Type='VIP'and c_address like '湖南%'

select top 10 percent * from Customers

select * from Customers where c_TrueName like '刘%'

select * from Customers order by year(getdate())-year(c_birth) desc

select * from Customers order by c_Type,year(getdate())-year(c_birth) desc

 

转载于:https://www.cnblogs.com/1992duanduan/archive/2013/04/19/3031246.html