select 语句关键字优先级

1、select 语句优先级

select  classid, userid, name, age  from  study   where  userid > 15  group  by   classid   having  classid > 89  order  by   classid  desc;

from > where > select > group by > having > order by

缘于生活,而归于工作。本人所书,而意于分享。 如有转载,请注明出处! --活出自己范儿
原文地址:https://www.cnblogs.com/Small-sunshine/p/10907546.html