Hung: SQL

顯示具有 SQL 標籤的文章。顯示所有文章

2012年5月23日星期三

--select * from Object

--select Title , Address from Object where Title like '%夜市%'

--select top 10 * from Object order by OID desc

--select Title, Address from Object where Title like '%埔里酒廠%'

--select * from Object where OID<10 order by OID desc

--select * from Object where Description like '%埔里% '

--select Title,Address

--from Class C , CO ,Object O

--where C.CName = '埔里鎮' and C.CID=CO.CID and CO.OID=O.OID