A quick Question. Suppose I have the following two queries:
SELECT TOP 2 * FROM Persons;
SELECT * FROM Persons limit 2;
I want to know the difference between the execution of the above 2 queries?
Basically, I want to know when should I use the
keyword and when it is appropriate to use the
Also, How does the database return results based on the above 2 queries.