Welcome to WebmasterServe!

FREE TO JOIN! Join us now to engage in informative and friendly discussions about Webmastering, SEO, SEM, Internet Marketing, Programming, Graphic Design, Online Jobs and more. What are you waiting for? Ready to join our friendly community? It takes just one minute to register.

Dismiss Notice

Join WebmasterServe Forums 
Join the discussion! Have a better idea or an opinion? It takes just one minute to register Click Here to Join

My 2 Cents The Top Keyword

Discussion in 'Database Management' started by Swati Mishra, Mar 17, 2016.

  1. Swati Mishra

    Yellow Belt

    Joined:
    Dec 28, 2015
    Messages:
    644
    Ratings:
    +105 / -0
    If you want to display the top few rows then use the TOP keyword with the SELECT statement, it will return limited number in the result.
    Syntax

    SELECT[TOP n[PERSCENT]] column_name [, column_name…]
    FROM table_name
    WHERE search_conditions
    [ORDER BY[column_name[,column_name….]
    Where n is the number of rows which you want to receive.
     

Share This Page