search only single record

Question

select table_a.Student_id,table_a. name , sum (table_b.amount) from table_a left outer join table_b on table_a.Student_id=table_b.student_id group by table_a.Student_id above code i want search only single record only above code is work for all records ...... how to use where condition ex:- tablename where id="232"

Ramesh Palanivel · Answer

Hi Vinay, Try this code, select table_a.Student_id,table_a. name , sum (table_b.amount) from table_a left outerjoin table_b on table_a.Student_id=table_b.student_id where table_a.id=232 group by table_a.Student_id

Tapan Patel · Answer

select table_a.Student_id,table_a. name , sum (table_b.amount) from table_a left outerjoin table_b on table_a.Student_id=table_b.student_id where table_a.Student_id=232 group by table_a.Student_id

Nilesh Shah · Answer

I think you need to use "HAVING" clause when you have to apply condition on a group then use "having" e.g. Select table_a.Student_id, table_a. name , sum (table_b.amount) From table_a left outerjoin table_b on table_a.Student_id = table_b.student_id Group by table_a.Student_id Having table_a.Student_id = "232"

Thennarasu N · Answer

/* your Should use where conidtion apply condition u which ever you want search i mentiion code used id u can using name and address. but must which value going to search this value its should available in the database table */ select table_a.Student_id,table_a.name,sum(table_b.amount) from table_a left outerjoin table_b on table_a.Student_id=table_b.student_id where table_a.Student_Id =2 group by table_a.Student_id