portal123
asked on
Get query where smallest numeric value
Hi, I would like to get a query where BID = the smallest value at the following mysql table. How can I get it? BestRegards, portal123
-------------------------- ---------- ---------- ---------- --
QID PRODUCT BID
-------------------------- ---------- ---------- ---------- --
1 a 16
-------------------------- ---------- ---------- ---------- --
2 b 8
-------------------------- ---------- ---------- ---------- --
3 g 5
-------------------------- ---------- ---------- ---------- --
4 h 1
-------------------------- ---------- ---------- ---------- --
5 q 18
-------------------------- ---------- ---------- ---------- --
continued........
--------------------------
QID PRODUCT BID
--------------------------
1 a 16
--------------------------
2 b 8
--------------------------
3 g 5
--------------------------
4 h 1
--------------------------
5 q 18
--------------------------
continued........
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.