复杂的sql语句,急
select case when len(title)>18 then left(title,18)+'...' else title end as title,[ID],[date],[content] from news order by ID DESC title,[ID],[date],[content] from news order by ID DESC
想在news 表里 取除 title ID date content 并且按ID反取,并且当title长度大于18时,采取前18个字+。。的显示方法
这样写对吗