Lazzycoder Code For Everyone

Have a Question?

If you have any question you can ask below or enter what you are looking for!

    Limit the numbers of results

    29-12-2015 17:56:41 MSSQL / Basics 0 Bookmark(s) 175 View(s)

     

    The number of rows in a result can be limited by number or by percentage using the TOPkeyword.

    
SELECT TOP 100 * FROM Customers;

    By Percentage:

    
SELECT TOP 50 PERCENT * FROM Customers;