A,查询字符串结果自动转大写函数
SELECT UCASE(column_name) FROM table_name举例如下:
SELECT UCASE(LastName) as LastName,FirstName FROM Persons
B,在 SQL 中增加 HAVING 子句原因是,WHERE 关键字无法与合计函数一起使用。
使用语法如下:
SELECT column_name, aggregate_function(column_name) FROM table_name WHERE column_name operator value GROUP BY column_name HAVING aggregate_function(column_name) operator value
带有参数的查询语句;
SELECT Customer,SUM(OrderPrice) FROM Orders WHERE Customer='Bush' OR Customer='Adams' GROUP BY Customer HAVING SUM(OrderPrice)>1500
C,NOW 函数返回当前的日期和时间。
SELECT NOW() FROM table_name
查询语句如下
SELECT ProductName, UnitPrice, Now() as PerDate FROM Products