您的位置: 首页 > IT文章 > SQL

SQL

分类: IT文章 • 2024-10-13 15:30:18

1. The basic structure

select

from

where

order by

2. Key:word:

distinct

3. Functions:

count( columName)

count(DISTINCT columeName)

min()

max()

char_length()

length()

substring(string, position, length)

4. join