Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Select Statement

Status
Not open for further replies.
GSMike

GSMike

Programmer
Joined
Feb 7, 2001
Messages
143
Location
US
I am accustomed to, in MS Access, saying:
Code: 
 select top 30 from mytable;

Is there a way to do this in SQL Server 6.5? I keep getting "error message near 30".

Thanking you in advance. Mike K
 
Sort by date Sort by votes
Top was implemented in SQL Server V7, I believe.
 
Upvote 0 Downvote
TOP is a new keyword in SQL Server 7.

It is not compatible with SQL Server 6 or 6.5 Kim
 
Upvote 0 Downvote
Great. Thanks for the definitive info. Mike K
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

SashaBuilder3
  • Locked
  • Question Question
select a single row based on conditions in multiple rows
Replies
3
Views
1K
SashaBuilder3
SashaBuilder3
grnzbra
  • Locked
  • Question Question
Create Function Within IF statement.
Replies
4
Views
2K
mikrom
mikrom
leifoet
  • Locked
  • Question Question
Error in Select query
Replies
14
Views
1K
Andrzejek
Andrzejek
grnzbra
  • Locked
  • Question Question
SELECT TOP 1 of Each of a Group
Replies
5
Views
742
grnzbra
grnzbra
Auguy
  • Locked
  • Question Question
Using UDF In Select, Bad Idea?
Replies
3
Views
546
Auguy
Auguy

Part and Inventory Search

Sponsor

Back
Top