sql篩選字段值唯一的語句 sql如何查詢包含某一字段的值?
sql如何查詢包含某一字段的值?對(duì)于不同的數(shù)據(jù)庫,SQL語句略有不同:1。對(duì)于access數(shù)據(jù)庫,SQL語句應(yīng)該是:select*from tablename where a like “*2011*
sql如何查詢包含某一字段的值?
對(duì)于不同的數(shù)據(jù)庫,SQL語句略有不同:1。對(duì)于access數(shù)據(jù)庫,SQL語句應(yīng)該是:select*from tablename where a like “*2011*”2。對(duì)于Oracle數(shù)據(jù)庫,SQL語句應(yīng)該是:select*from tablename where a like“11%”3。對(duì)于SQL Server數(shù)據(jù)庫,SQL語句應(yīng)該是:select*from tablename,其中類似“11%”