SQL 函数

最新推荐文章于 2022-08-04 11:27:45 发布

金融小白数据分析之路

最新推荐文章于 2022-08-04 11:27:45 发布

阅读量113

点赞数

分类专栏：数据库使用

本文链接：https://blog.csdn.net/weixin_45631815/article/details/116007264

版权

数据库使用专栏收录该内容

26 篇文章 1 订阅

订阅专栏

SELECT ABS(-2)
SELECT MOD(101,3)
SELECT ROUND(37.25,1)

SELECT CONCAT('ABC','123')
SELECT LENGTH('你好')
SELECT CHAR_LENGTH('你好')
SELECT LOWER('ABC')
SELECT REPLACE('fabcd','abc',123)
SELECT SUBSTRING('fabcd',1,3)

SELECT CURRENT_DATE()
SELECT CURRENT_TIME()
SELECT CURRENT_TIMESTAMP()
SELECT EXTRACT(YEAR FROM '2021-04-20')
SELECT DATE('2019-04-01 12:00:05')

SELECT CAST(123.123 AS DECIMAL(8,2))
SELECT COALESCE(NULL,1,2)

SELECT NAME,ROUND(ATTACK_GROWTH,1) FROM HEROS
SELECT name, ROUND(attack_growth,1) FROM heros
SELECT MAX(hp_max) from heros
SELECT name,hp_max from heros WHERE hp_max=(SELECT MAX(hp_max) from heros)
SELECT CHAR_LENGTH(name),name FROM heros
SELECT name,EXTRACT(year from birthdate) as birthdate from heros WHERE birthdate is not  null
SELECT name,YEAR(birthdate) as birthdate from heros WHERE birthdate is not  null
SELECT * from heros WHERE date(birthdate)>'2016-10-01'