sql查詢一個(gè)字段多個(gè)值 sql如何查詢包含某一字段的值？
sql如何查詢包含某一字段的值？不同的數(shù)據(jù)庫，SQL語句略有區(qū)別：1.如果是Access數(shù)據(jù)庫，SQL語句應(yīng)為：SELECT * FROM TableName WHERE A LIKE "*2011*
sql如何查詢包含某一字段的值？
不同的數(shù)據(jù)庫，SQL語句略有區(qū)別：1.如果是Access數(shù)據(jù)庫，SQL語句應(yīng)為：SELECT * FROM TableName WHERE A LIKE "*2011*"2.如果是Oracle數(shù)據(jù)庫，SQL語句應(yīng)為：SELECT * FROM TableName WHERE A LIKE " 11%"3.如果是SQL SERVER數(shù)據(jù)庫，SQL語句應(yīng)為：SELECT * FROM TableName WHERE A LIKE " 11%"
sql如何查詢包含某一字段的值？
最簡單的子查詢：select * from table where date = (select max(date) from table) 或者用輪子哥講的join自己： select * from table t1 left join (select max(date) as date from table) t2 on t1.date=t2.date where t2.date is not null