Quote:
Originally Posted by Banana
Is that for a different SQL dialect? I only do that with either TOP for T-SQL or LIMIT for MySQL.
|
That's for T-SQL. I don't have a MySQL handy* to check if it applies there, too, but I would assume as much.
And TOP and LIMIT are actually not the same. Those give you a specific amount of rows; "SELECT 1" gives you a specific content within the rows; the amount of rows depends on the table's existing data.
*) Okay, okay: I'm just too lazy.