1. SELECT* FROM tn WHERE FN LIKE '_in%' (%省略)
- LIKE '[TJ]im%'. (TJ有一个在)
- LIKE '[^TJ]im%'. (不是T或者J开头)
- LIKE '%' + 'im' + '%' (搜索字符串)
2. ROW_Number 函数
- SELECT ROW_NUMBER() OVER (ORDER BY ProductID) AS ROWNumber, ProductNumber,
1. SELECT* FROM tn WHERE FN LIKE '_in%' (%省略)
2. ROW_Number 函数