Limiting result to the first row returned in query

General Discussion
,
1

I have a SQL statement that I want to linit my results to the top row of returned data, but I am getting an error.

SELECT * FROM BACON_ASSEMBLY_LOG with (nolock)
Where StationID = '137'
order by StartTimeStamp desc
Fetch fetch next 3 rows only

2

Depends on the type of database. Some have you put TOP 3 right after SELECT, others have you put LIMIT 3 at the end.

2 Likes
3

The Data query browser is where I am writing the query. so, would that be Select Top

4

It depends on the type of database. MySQL, MSSQL, PostgreSQL, Oracle, SQLite, etc.

4 Likes