[Un-Solved] First instance only
Posted: Wed Jul 20, 2005 10:58 am
Kind of a stupid question but I've never encountered this.
Lets say my table had a column called "troutd", how could I grab only the first instance of that troutd only using mysql 4.1
For example the column would look like
TROUTD
1
2
3
4
5
4
1
3
4
5
I only want to grab the first instance of each number, but the problem is I will be joining multiple tables together and don't need to just get the distinct troutd. Not sure how to go about getting multiple columns where 1 column is only distinct. Help appreciated. Thanks
Edit | added to post
Lets say my table had a column called "troutd", how could I grab only the first instance of that troutd only using mysql 4.1
For example the column would look like
TROUTD
1
2
3
4
5
4
1
3
4
5
I only want to grab the first instance of each number, but the problem is I will be joining multiple tables together and don't need to just get the distinct troutd. Not sure how to go about getting multiple columns where 1 column is only distinct. Help appreciated. Thanks
Edit | added to post