Syntax: SELECT TOP n select_list FROM T Get top n records FROM T Get top n records from each group according to ortop, limit,offset