
Select Maximum Five Result
Question: How do I find out the top-five best sale items? I want the maximum five items to be listed. Answer: In version 7, SQL Server has conveniently provided the TOP keyword. So, using the pubs database for an example, the following query will return the books with the top