select * from table name;
in the table all details are displayed. ok fine.
--course wise query
select Date,Session,Faculty_Code from Tb_SCh_TIme_Table where Course='REO' order by Date,session
when i run above query for particular course REO i get the ouput.ok fine.
Date Session Faculty_Code
2013-01-07 1 GS
2013-01-07 2 NR
2013-01-07 3 RJ
2013-01-07 4 CM
2013-01-08 1 RK
2013-01-08 2 CM
2013-01-08 3 NR
2013-01-08 4 SJ
But i want the output for All course means how can i do to write the query for all course.
how can i do, for all course details to get the output.
help me.