Try to search your question here, if you can't find : Ask Any Question Now ?

How to delete result query from sql?

HomeCategory: stackoverflowHow to delete result query from sql?
Avatarsourav asked 2 weeks ago

i want to delete this result form database…please healp me.

select *
FROM stock_batch AS a
INNER JOIN
(
SELECT stockid, Max(batchid) AS batchid
FROM stock_batch
GROUP BY stockid
) AS b
ON a.stockid = b.stockid
AND a.batchid < b.batchid

1 Answers
Best Answer
AvatarMikhail answered 2 weeks ago
Your Answer

0 + 3 =

Popular Tags

WP Facebook Auto Publish Powered By : XYZScripts.com