<b>SQL条件语句实例</b>[MSSQL防范]
本文“<b>SQL条件语句实例</b>[MSSQL防范]”是由七道奇为您精心收集,来源于网络转载,文章版权归文章作者所有,本站不对其观点以及内容做任何评价,请读者自行判断,以下是其具体内容:
在SQL语句中,SQL条件语句无疑是利用最广,最常见的SQL语句之一,下面就将为您介绍几个利用SQL条件语句,供您学习参考.
----查询StudentMarks 最大的前三条记录
select top 3 StudentID,StudentName,Mark from StudentMarks order by Mark desc
----查询StudentMarks 的第30~40条记录
1、早年30条的背面, 取前10条
select top 10 * from StudentMarks where StudentID not in(select top 30 StudentID from StudentMarks)
2、先正序取40条, 再反序取10条
select top 10* from (select top 40* from StudentMarks order by Mark ) a
order by Mark desc
3、、操纵暂时表
select top 40 * into #Stm from StudentMarks order by Mark
select top * from #Stm order by Mark desc
----查询和London同属于一个国家的城市的客户
select distinct * from customers where country in
( select country from customers where city='London')
----查询和London,Paris同属于一个国家的城市的客户
select * from customers where country in
(select country from Customers where City in ('London','Paris'))
----查询单价大于Dofu的产品名
select ProductName from Products where UnitPrice>
(select UnitPrice from Products where ProductName='Tofu')
以上是“<b>SQL条件语句实例</b>[MSSQL防范]”的内容,如果你对以上该文章内容感兴趣,你可以看看七道奇为您推荐以下文章:
本文地址: | 与您的QQ/BBS好友分享! |