postgresql 大小写，别名
时间：2021-07-01 10:21:17
帮助过：53人阅读
ask.id "id",ask.createTime "createTime",ask.publisherID "publisherID",users.nickname "nickname",
users.icon "icon",users.gender "gender",ask.reward "reward",ask.zan "zan",ask.commentID "commentID",
ask.typee "type",ask.label "label",ask.content "content",ask.image "
image",
count(comment.id) "commentCount"
from ask
inner join users
on ask.publisherID
=users.id
left outer join comment
on comment.objectID
= ask.id
group by ask.id,users.nickname,users.icon,users.gender
order by "createTime"
desc
limit 10 offset
0;
postgresql默认全部小写，若要区分字段名大小写需要用引号括住
postgresql 大小写，别名
标签：大小写 desc image font select icon count class 字段名
