62
3
MESSIAH
posted Apr 2 '20 at 10:39 am
Select only one row with minimum id from table containing specified value.
Here 's my table
id
A
B
1
A1
A
2
A2
B
3
A3
B
And here's my query
"SELEC * FROM table WHERE B = B"
This query return all rows containing 'B'. How to get lowest id from this query?
Here 's my table
id
A
B
1
A1
A
2
A2
B
3
A3
B
And here's my query
"SELEC * FROM table WHERE B = B"
This query return all rows containing 'B'. How to get lowest id from this query?
recent by MESSIAH
· Apr 12 '20 at 6:20 am