08-10-17, 04:42 PM
جرب الكود التالي مع تغيير ما يلزم
PHP كود :
SELECT TOP 1 *, (SELECT TOP 1 SAL FROM (SELECT TOP 2 ID, SAL FROM SalTable WHERE Emp = 1 ORDER BY ID DESC) x ORDER BY ID)
FROM SalTable WHERE Emp = 1 ORDER BY ID DESC