sql如何查詢包含某一字段的值？不同的數據庫，SQL語句略有區別：1.如果是Access數據庫，SQL語句應為：SELECT * FROM TableName WHERE A LIKE "*2011*

sql如何查詢包含某一字段的值？

不同的數據庫，SQL語句略有區別：1.如果是Access數據庫，SQL語句應為：SELECT * FROM TableName WHERE A LIKE "*2011*"2.如果是Oracle數據庫，SQL語句應為：SELECT * FROM TableName WHERE A LIKE " 11%"3.如果是SQL SERVER數據庫，SQL語句應為：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

用SQL怎樣查詢到包含有某個字段的所有表名？

select a.name 表名，b.name 列名 from sysobjects a，syscolumns b where a.id = b.id and b.name = "表名"and a.type="U"

還有一種：

SELECT b.name as TableName，a.name as columnname

From syscolumns a INNER JOIN sysobjects b

ON a.id=b.id

AND b.type=’U’

AND a.name=’你的字段名字’