SQL

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 

posted @ 2019-12-31 07:13  心怀阳光  阅读(68)  评论(0编辑  收藏  举报