2.23
来源:互联网 发布:淘宝十元包邮专区 编辑:程序博客网 时间:2024/06/05 03:56
今天通过一天的听课
比如:
select * from T_UserInfo
where Address='邯郸' or Name='李哲'
select * from T_UserInfo where Name='李哲'
select * from T_UserInfo order by Age desc
select top 2* from T_UserInfo
--查询姓名的最后一个字为“哲”的数据,前边可以有一个或多个任意字符
select * from T_UserInfo WHERE Name LIKE '%哲'
--查询姓名的第一个字为“李”的数据,后边可以有一个或多个任意字符
select * from T_UserInfo WHERE Name LIKE '李%'
--查询姓名的最后一个字为“哲”的数据,前边可以有一个任意字符
select * from T_UserInfo where Name like '_哲'
--查询姓名的最后一个字为“李”的数据,后边可以有一个任意字符
select * from T_UserInfo WHERE Name LIKE '李_'
--in 运算符可以看成多个or 连接
select * from T_UserInfo WHERE
Age=27 or Age=20 or Age=19 or Age=21
select * from T_UserInfo WHERE Age in(30,20,19,21)
select * from T_UserInfo WHERE Age BETWEEN 19 and 30
select Name,Tell,Address from T_Userinfo where Name='李哲'
union
select Name,Tell,Address from T_UserInfo WHERE Age=21
--创建视图
create view v1 as
select top 3* from T_UserInfo WHERE Age>21
SELECT * FROM v1
UPDATE T_UserInfo SET Age=26 WHERE Name='姚宏波'
select * from T_UserInfo
UPDATE v1 SET Age=20 WHERE Name='李英哲'
DELETE FROM v1 WHERE Name='姚宏波'
select ROUND(AVG(numbs),1) from testgroup;
select SUM(numbs) from testgroup;
SELECT COUNT(*) FROM T_UserInfo;
SELECT MAX(Numbs) as numbs from testgroup;
SELECT min(Numbs) as numbs from testgroup;
SELECT min(name) as numbs from testgroup
SELECT MAX(name) as numbs from testgroup
SELECT MAX(fuhao) as numbs from testgroup
SELECT min(fuhao) as numbs from testgroup
select name, SUM(numbs)numbs from testgroup
group by(name) order by(numbs)
和
FileStream fs = new FileStream("C:\\Documents and Settings\\Administrator\\桌哩
比如:
select * from T_UserInfo
where Address='邯郸' or Name='李哲'
select * from T_UserInfo where Name='李哲'
select * from T_UserInfo order by Age desc
select top 2* from T_UserInfo
--查询姓名的最后一个字为“哲”的数据,前边可以有一个或多个任意字符
select * from T_UserInfo WHERE Name LIKE '%哲'
--查询姓名的第一个字为“李”的数据,后边可以有一个或多个任意字符
select * from T_UserInfo WHERE Name LIKE '李%'
--查询姓名的最后一个字为“哲”的数据,前边可以有一个任意字符
select * from T_UserInfo where Name like '_哲'
--查询姓名的最后一个字为“李”的数据,后边可以有一个任意字符
select * from T_UserInfo WHERE Name LIKE '李_'
--in 运算符可以看成多个or 连接
select * from T_UserInfo WHERE
Age=27 or Age=20 or Age=19 or Age=21
select * from T_UserInfo WHERE Age in(30,20,19,21)
select * from T_UserInfo WHERE Age BETWEEN 19 and 30
select Name,Tell,Address from T_Userinfo where Name='李哲'
union
select Name,Tell,Address from T_UserInfo WHERE Age=21
--创建视图
create view v1 as
select top 3* from T_UserInfo WHERE Age>21
SELECT * FROM v1
UPDATE T_UserInfo SET Age=26 WHERE Name='姚宏波'
select * from T_UserInfo
UPDATE v1 SET Age=20 WHERE Name='李英哲'
DELETE FROM v1 WHERE Name='姚宏波'
select ROUND(AVG(numbs),1) from testgroup;
select SUM(numbs) from testgroup;
SELECT COUNT(*) FROM T_UserInfo;
SELECT MAX(Numbs) as numbs from testgroup;
SELECT min(Numbs) as numbs from testgroup;
SELECT min(name) as numbs from testgroup
SELECT MAX(name) as numbs from testgroup
SELECT MAX(fuhao) as numbs from testgroup
SELECT min(fuhao) as numbs from testgroup
select name, SUM(numbs)numbs from testgroup
group by(name) order by(numbs)
和
FileStream fs = new FileStream("C:\\Documents and Settings\\Administrator\\桌哩
- 2.23
- 2.23
- 黄迪明2.23
- ./glibc-2.23
- 2005/2.23/sunny
- OSEK 2.23的中文版
- 2013年2.23 周六
- sicp 习题 2.23
- Binutils-2.23.2
- 入门HTML之2.23
- 入门HTML之2.23
- IOS审核 2.23问题
- 安装binutils 2.23.2
- hisiv400+glibc-2.23编译
- 练习2.21 2.23
- iis5+tomcat5+jk1.2.23整合
- webalizer-2.23-05 for squid
- SICP习题解答2.17-2.23
- UISegmentedControl控件
- 总有一种力量,能够让你思绪万千
- 吸心大法
- 在导航栏中添加UISegmentedControl
- 在Tomcat和Eclipse进行远程调试的配置
- 2.23
- 卸载mac上老版本的xcode方法
- 关于拒绝服务攻击的一点初步思考
- 关于 java.util.concurrent 您不知道的 5 件事,第 1 部分
- 关于 java.util.concurrent 您不知道的 5 件事,第 2 部分
- libcurl教程
- Hibernate中openSession 和 getCurrentSession 的区别
- Jmeter进行性能测试时多台负载机的配置方法
- win32 com_error: -2147221008 错误解决(转)