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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-05-14 : 10:41:48
|
| raffi writes "I have very big table (120,000 records).I have to write query that reads the first 100 records, with out knowing the table fields (by using the format select * from table_name)who can i do it ?who can i build query that readingjust the 50, 100, 200 first records with out knowing any of the table records ?thanks a lot." |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2003-05-14 : 10:45:15
|
| You can use the TOP keyword:select top 100 * from table_name |
 |
|
|
Raffib
Starting Member
2 Posts |
Posted - 2003-05-14 : 11:00:02
|
| Hi Andraax.first thanks for your help.second, it isn't work cos i'm not working with SQL SERVER but with Pervasive Sql Server, and it isn't work there.do you know that one ?if yes or you have other idea it will help.thanks.Raffi Brucker |
|
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2003-05-14 : 11:22:35
|
| Hi!This forum is mainly populated by MS SQL Server nerds :), so you might not get the best possible answer here. Try this link:[url]http://www.tek-tips.com/gthreadminder.cfm/lev2/4/lev3/27/pid/318[/url]Having said that:Pervasive as I know it has no equivalent of the TOP keyword. It will, however, be included in the next version (8) of the software.Good luck! |
|
|
|
Raffib
Starting Member
2 Posts |
Posted - 2003-05-14 : 13:39:37
|
Tanks a lot  Raffi Brucker |
|
|
|
|
|
|
Sql Problem