poshka Newbie Poster 3 posts since Dec 2013 Reputation Points: 0 [?] Q&As Helped to Solve: 0 [?] Skill Endorsements: 0 [?] 0 6 Months Ago I have three tables 1.course(c_id(pk),c_name,sem_no); 2.student(s_id(pk),s_name,user_name,password); 3.student_info(s_id(fk),c_id(fk)); i have logged in the student.. den i run this query select distinct sem_no from course,student_info where course.c_id=student_info.c_id and s_id='0001' order by sem_no; it shows all the semster he passed inclueding the running semster.. now i want to show the last value of sem_no coloumn as his current semster.. how can i grab the last value of the sem_no???