How to return only the first row....

feign3 · #1 (**permalink**) 01-16-03, 12:52

Is there a way to return only the first row of a multi-row query. In other words... I have a query returning multiple rows but I want it to stop after it retrieves the first row.

Thanks

rajXesh · #2 (**permalink**) 01-16-03, 13:14

In Oracle you would add

AND ROWNUM = 1

to the WHERE clause

-- rajXesh

feign3 · #3 (**permalink**) 01-16-03, 14:27

Thanks rajXesh!

acg_ray · #4 (**permalink**) 01-17-03, 09:48

Is there a similar command for SQL Server?

Joel · #5 (**permalink**) 01-17-03, 10:15

Quote:

Originally posted by acg_ray
Is there a similar command for SQL Server?

SELECT TOP 1 * FROM [table]

acg_ray · #6 (**permalink**) 01-20-03, 15:10

Thx Joel. That did it.

Internet Services

Web Development

Digital Marketing

Consumer Tech