Dear All,
I have a table structure like this:
create table seminar_details(id int(6) primary key auto_increment not null,
venue_id int(6) not null,
seminar_date_time datetime NOT NULL);
and the data in this table is:
insert into seminar_details values('',1,'2002-01-10 09:00:00');
insert into seminar_details values('',2,'2001-01-10 08:00:00');
insert into seminar_details values('',2,'2001-02-20 09:00:00');
Now I want to select these values based on ascending order of date.(i.e.,the earliest date should come first). For this I wrote a query like this which is not giving me any order:
select id,venue_id,seminar_date_time
from seminar_details where venue_id=2 order by seminar_date_time;
Hence I request you all to please tell me a query which selects the earliest date first based on the condition.
Thanking you,
regards,
Indrajit.
