How do you select Top 3 records from your database

How do you select Top 3 records from your database

Step 1

To select top 3 records from all you need to do is issue this command in SQL Analyzer

Select top 3 * from employees

Step 2

You can use a number to denote the number of records to return or percentage to do it.

Select top 30 percent * from employees

An example of screen layout is shown below:



Edited By:Melanie Michael Jominin

© 2001 ISC/Inner Esteem

All rights reserved. All other product names and trademarks are registered properties of their respective owners.

301001