Hi,
As a beginner, this may be a silly question. Please bear with me.
I have a table with around 12 columns and the primary key an "id" being a sequential number statrting from 1, 2.. etc and the last column status of int type 0 or 1. (mySql databse)
I have to select one row whose status is 0 and the smallest "id" in the ascending order.
id ................. status
1 1
2 1
3 0
4 0
5 0
From the above example I need to pick up the 3 rd record. Could any one help me on this issue?
Thanks
Gopu