Heist
-
Posts
2 -
Joined
-
Last visited
Never
Heist's Achievements
Newbie (1/5)
0
Reputation
-
Yeah, the more I use it, the more limitations I find. Thanks for the help.
-
Okay, here\'s what the query would look like in MSSQL: SELECT *, (SELECT id FROM table ORDER BY id DESC LIMIT 1) AS Last, (SELECT id FROM table ORDER BY id ASC LIMIT 1) AS First FROM table WHERE id = XXX This query doesn\'t work in SQL, does anyone knows why? Thanks.