I have been worried about my SQL level and have no idea how to improve it. Today I have collected this classic summary,
Once learned, they are commonly used statements. I will read one sentence every day.
SQL full 1 (using files and file groups. SQL)
Http://www.0379zd.com/news/show/81005.htm
SQL Daquan 2 (examples of CONVERT in date conversion. SQL)
Http://www.0379zd.com/news/show/82001.htm
SQL Daquan 3 (special date addition and subtraction functions. SQL)
Http://www.0379zd.com/news/show/82002.htm
SQL Daquan 4 (workday processing functions (Standard holidays). SQL)
Http://www.0379zd.com/news/show/82003.htm
SQL Daquan 5 (complex year-end processing. SQL)
Http://www.0379zd.com/news/show/81006.htm
SQL Daquan 6 (Statistics-cross tabulation + date + priority. SQL)
Http://www.0379zd.com/news/show/82004.htm
SQL Daquan 7 (examples of various string merge processing. SQL)
Http://www.0379zd.com/news/show/82005.htm
SQL row and column Interchange
Http://www.0379zd.com/news/show/81004.htm