retrieve 1st record

[lukeurtnowski]

I'm trying to figure out how to create a select statement to retrieve a record from a set of records with the lowest primary key?
Any Takers?

[r937]

a "set of records"??? do you mean a table?

SELECT columns
  FROM daTable
 WHERE pk = ( SELECT MIN(pk) FROM daTable )

[lukeurtnowski]

Yea, like if I return all records of a certain email, the how do I only select the record with the lowest primary key?
Thanks

[r937]

Yea, like if I return all records of a certain email, the how do I only select the record with the lowest primary key?
Thanks

see post #2 in this thread

[lukeurtnowski]

thx. (nice car!)

[r937]