Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 select first several rows from table.

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-01-01 : 23:05:38
wenze writes "I have a huge table, but i want to get first several rows for testing my JSP page to save time. Could you tell me how to do this?

thanx

wenze"

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2002-01-01 : 23:10:42
Hi

SELECT Top 10 * FROM MyTable

Hope that helps

Damian
Go to Top of Page
   

- Advertisement -