Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Return whole record with max value on one column 1

Status
Not open for further replies.
uconn1981

uconn1981

Programmer
Mar 21, 2005
42
US
I need to select the whole record based on the max vlaue on one of the fields. How to do that?

Thanks,

Tim
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

BobThornton
  • Locked
  • Question
Count records until a record value changes
Replies
2
Views
221
carp
carp
mmiah1982
  • Locked
  • Question
Extracting mutiple data items from DB with JSON string format column
Replies
2
Views
145
mmiah1982
mmiah1982
szeiss
  • Locked
  • Question
Need to select the one value if it exists otherwise another value
Replies
4
Views
156
szeiss
szeiss
Tetol
  • Locked
  • Question
Update script is changing the number of records for the values updated each time I run the query
Replies
1
Views
128
carp
carp
fredong
  • Locked
  • Question
Update upper row data with next row data that was detached partially from import.
Replies
6
Views
193
carp
carp

Part and Inventory Search

Sponsor

Back
Top