Returning TOP records
Microsoft SQL Server
– SELECT TOP 10 column FROM table
My SQL
– SELECT column FROM table LIMIT 10
Returning TOP PERCENT Records
Microsoft SQL Server
– SELECT TOP 50 PERCENT * FROM table
MySQL
– SELECT @percentage := ROUND(COUNT(*) * 50/100) FROM table;
PREPARE STMT FROM ‘SELECT * FROM table LIMIT ?’;
EXECUTE STMT USING @percentage;
