sqlServer2005
涔犻涓庣瓟妗?/p>
浠庡鐢熻〃
Student(Sno,Sname,Ssex,Sage,Sdept)
涓煡
璇㈠嚭鍏ㄤ綋瀛︾敓鐨勫鍙蜂笌濮撳悕
1.
鏌ヨ鍏ㄤ綋瀛︾敓鐨勮缁嗚褰?/p>
2.
鏄剧ず鍓?/p>
5
鏉＄邯褰?/p>
3.
鏄剧ず鍓?/p>
50%
鏉＄邯褰?/p>
4.
鏌ヨ鎵�鏈夊勾榫勫湪
17
宀佷互涓嬬殑瀛︾敓濮撳悕鍙婂叾骞撮緞銆?/p>
5.
鏌愪簺瀛︾敓閫変慨璇剧▼鍚庢病鏈夊弬鍔犺�冭瘯
,
鎵�浠ユ湁閫夎璁?/p>
褰?/p>
,
浣嗘病鏈夎�冭瘯鎴愮哗銆?/p>
鏌ヨ缂哄皯鎴愮哗鐨勫鐢熺殑瀛﹀彿鍜岀浉搴旂殑璇?/p>
绋嬪彿銆?/p>
锛堟垚缁╀负
null
锛?/p>
6.
鏌ユ墍鏈夋湁鎴愮哗鐨勫鐢熷鍙峰拰璇剧▼鍙?/p>
7.
鏌ヨ瀛︾敓鐨勬墍鏈変俊鎭紝鎸夊鍙风殑闄嶅簭鎺掑垪
1.select *
from student
2.select top 5 *
from student
3.select top 50 percent *
from student
4.select sname,sage
from student
where
sage<17
5.select sno,cno
from sc
where score is
NULL
6.select sno,cno
from sc
where score is not
NULL