动易文章不同栏目分类sql 语句

select * from pe_commonmodel order by nodeid

select * from pe_commonmodel where generalid in (select max(generalid) generalid   from pe_commonmodel group by nodeid)  --找到某个栏目下的ID号最大的文章列表

select * from pe_commonmodel where inputtime in (select max(inputtime) inputtime   from pe_commonmodel group by nodeid)  --找到某个栏目下的输入时间最新的文章列表