首先大家看看这句到底有没错?如果错了,请大虾帮忙改正。
SELECT huadu_news_list.*, huadu_news_upimglog.id AS imgid,
huadu_news_upimglog.img_id AS img_id,
huadu_news_upimglog.img_url AS img_url,
huadu_news_upimglog.news_id AS news_id
FROM huadu_news_upimglog INNER JOIN
huadu_news_list ON huadu_news_upimglog.news_id = huadu_news_list.id
WHERE (huadu_news_upimglog.id IN
(SELECT MAX(id)
FROM huadu_news_upimglog
GROUP BY news_id
HAVING COUNT(news_id) >= 1)) AND (huadu_news_upimglog.img_id = 7) (CHARINDEX(',30,', ',' + special + ',') > 0 ) order by huadu_news_list.id desc------------------------------------
好了,我正式来提问我的问题。大家看到了,那个数字"30"了吗?
上面的语句关系到2个表: huadu_news_list huadu_news_upimglog
下面我来解释一下"30",我还有一个表叫huadu_news_pop
现在我需要“30”变成huadu_news_pop表中第二大的id ,
我改怎么办?一天都没解决.唉.那位帮忙~~谢谢了.
SELECT huadu_news_list.*, huadu_news_upimglog.id AS imgid,
huadu_news_upimglog.img_id AS img_id,
huadu_news_upimglog.img_url AS img_url,
huadu_news_upimglog.news_id AS news_id
FROM huadu_news_upimglog INNER JOIN
huadu_news_list ON huadu_news_upimglog.news_id = huadu_news_list.id
WHERE (huadu_news_upimglog.id IN
(SELECT MAX(id)
FROM huadu_news_upimglog
GROUP BY news_id
HAVING COUNT(news_id) >= 1)) AND (huadu_news_upimglog.img_id = 7) (CHARINDEX(',30,', ',' + special + ',') > 0 ) order by huadu_news_list.id desc------------------------------------
好了,我正式来提问我的问题。大家看到了,那个数字"30"了吗?
上面的语句关系到2个表: huadu_news_list huadu_news_upimglog
下面我来解释一下"30",我还有一个表叫huadu_news_pop
现在我需要“30”变成huadu_news_pop表中第二大的id ,
我改怎么办?一天都没解决.唉.那位帮忙~~谢谢了.
id为递增