The TOP clause is used to specify the number of records to be fetched. It is very useful on large tables with millions of records. Because SELECT query can also take more time and degrade your database performance.

Structure of TOP statement:
SELECT TOP 10 NAME_field FROM table_name

So use TOP and get some specific result without any performance impact.

Posted in MySQL | Tagged , , | Comments Off

Comments are closed.