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?
| SitePoint Sponsor |





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?
"Oh, and Jenkins--apparently your mother died this morning."


a "set of records"??? do you mean a table?
Code:SELECT columns FROM daTable WHERE pk = ( SELECT MIN(pk) FROM daTable )





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
"Oh, and Jenkins--apparently your mother died this morning."







thx. (nice car!)
"Oh, and Jenkins--apparently your mother died this morning."


Bookmarks