No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
It is the student_info table CREATE TABLE student_info ( s_id varchar(50) NOT NULL, c_id varchar(50) , sem_no varchar(50), quiz_mark varchar(50) , att_mark varchar(50), total_mark varchar(50), exam_mark varchar(50), grade varchar(50), ); insert into student_info values('0006','chem1115','1','15','9',' ','59 ',' '); insert into student_info values('0006','cse101','1','15','9',' ','70 ',' '); insert into student_info values('0006','cse111','1','15','9',' ','49 ',' … |
|
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 … |