access查询top10产品

发布时间：2024-12-02 20:52

3C产品防伪查询：可在线查询购买产品的真伪信息。 #生活知识# #科技生活# #3C资讯#

SELECT top 10 jobid,

classid,

jobname,

provincecode,

citycode,

peaplenum,

publishtime,

remark,

table_b.totalcount,

table_c.classname

FROM t_jobs,

(SELECT count(jobid) as totalcount

FROM t_jobs

WHERE isdelete = 0

and jobname like '%销%') as table_b,

(select name AS classname

from t_classify

where t_jobs.classid = t_classify.classid

and t_classify.isdelete = 0) as table_c

WHERE isdelete = 0

and (jobname like '%销%')

and not exists (select top 50 jobid

from t_jobs

where isdelete = 0

and jobid = t_jobs.jobid

and (jobname like '%销%')

order by jobid desc)

order by jobid desc

网址：access查询top10产品 https://www.yuejiaxmz.com/news/view/351612