Select TOP 1 in SQL Server 6.5
I beg you don't ask me why am I using SQL Server 6.5 There is no SELECT TOP command in SQL Server 6.5, and guess what, I need it :) I need to perform something like Select top 1 * from persons where name ='Mike' order by id desc I've tried something with SET ROWCOUNT 1, but in that case you cannot use order by. I end up with Sele...