How to get max data in query..............
Posted: Sat Feb 13, 2010 8:26 am
hai i have a tabel called studentqualification and one table studentdetailtb .
when i insert the data in to the table the data has save both table education part saved in studentqualificationtb and student general information part save in studentdetailtb
my problem is that i want to fetch information from both table with student highest qualification...
studentqualification structure are like:
----------------------------------------
TempID class Year Universities Division
-----------------------------------------
ATC01 BCA 2006 HU 1st
ATC01 MCA 2009 HU 1st
--------------------------------------------
when the data will fetch it will take only highest Class like MCA and Year 2009.
when i insert the data in to the table the data has save both table education part saved in studentqualificationtb and student general information part save in studentdetailtb
my problem is that i want to fetch information from both table with student highest qualification...
studentqualification structure are like:
----------------------------------------
TempID class Year Universities Division
-----------------------------------------
ATC01 BCA 2006 HU 1st
ATC01 MCA 2009 HU 1st
--------------------------------------------
when the data will fetch it will take only highest Class like MCA and Year 2009.