SQL小测试
来源:互联网 发布:spss mac 教程 编辑:程序博客网 时间:2024/06/07 17:30
1.SQL 指的是?
错误答案:SELECT * FROM Persons WHERE FirstName='a'
错误答案:SELECT * FROM Persons WHERE FirstName LIKE 'Thomas' AND LastName LIKE 'Carter'
错误答案:SELECT * FROM Persons WHERE LastName>'Adams' AND LastName<'Carter'
错误答案:SELECT * FROM Persons ORDER FirstName DESC
错误答案:INSERT VALUES ('Jimmy', 'Jackson') INTO Persons
错误答案:INSERT ('Wilson') INTO Persons (LastName)
错误答案:UPDATE Persons SET LastName='Wilson' INTO LastName='Gates'
Structured Query Language
SELECT
UPDATE
DELETE
INSERT INTO
SELECT FirstName FROM Persons
SELECT * FROM Persons
SELECT * FROM Persons WHERE FirstName='Peter'
错误答案:SELECT * FROM Persons WHERE FirstName='a'
正确答案:SELECT * FROM Persons WHERE FirstName LIKE 'a%'
正确
错误答案:SELECT * FROM Persons WHERE FirstName LIKE 'Thomas' AND LastName LIKE 'Carter'
正确答案:SELECT * FROM Persons WHERE FirstName='Thomas' AND LastName='Carter'
错误答案:SELECT * FROM Persons WHERE LastName>'Adams' AND LastName<'Carter'
正确答案:SELECT * FROM Persons WHERE LastName BETWEEN 'Adams' AND 'Carter'
13.哪条 SQL 语句可返回唯一不同的值?
错误答案:SELECT UNIQUE正确答案:SELECT DISTINCT
ORDER BY
错误答案:SELECT * FROM Persons ORDER FirstName DESC
正确答案:SELECT * FROM Persons ORDER BY FirstName DESC
错误答案:INSERT VALUES ('Jimmy', 'Jackson') INTO Persons
正确答案:INSERT INTO Persons VALUES ('Jimmy', 'Jackson')
错误答案:INSERT ('Wilson') INTO Persons (LastName)
正确答案:INSERT INTO Persons (LastName) VALUES ('Wilson')
错误答案:UPDATE Persons SET LastName='Wilson' INTO LastName='Gates'
正确答案:UPDATE Persons SET LastName='Wilson' WHERE LastName='Gates'
DELETE FROM Persons WHERE FirstName = 'Fred'
SELECT COUNT(*) FROM Persons
阅读全文
2 0
- SQL小测试
- spark sql 测试小程序
- sql cursor 简单测试小实例
- 一个SQL大牛提的一个sql优化小测试
- SQL Server 文档整理 - 5 胸闷测试小程序^_^
- SQL小测试1:这样的要求你需要多长时间?
- SQL小测试2:这样的要求你需要多长时间?
- 做sql性能测试时要注意的小问题
- 小测试
- 小测试
- 小测试
- SQL 测试 !!!
- SQL测试
- SQL-测试
- 测试小技巧-黑盒测试
- 逻辑小测试
- 性能测试小Tips
- 爱情小测试
- SwipeRefreshLayout源码分析+自定义UC头条下拉刷新Demo
- hdu2048 神、上帝以及老天爷(C语言)
- RPC的理解
- [RK3288][Android6.0] Apk设置显示旋转过程小结
- 如何训练Tesseract 4.0
- SQL小测试
- Vend Aging Report数据存储转换图
- Eclipse svn插件安装详细教程
- HashMap
- android:supoort.v4.view.ViewCompat.getDisplay(Landroid/view/View;)Landroid/view/Display;
- String类——练习(4)
- ActiveMQ从初识到使用(一)
- 使用md5的算法进行加密
- 技术花絮