search only single record

Question

select table_a.Student_idtable_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_idtable_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_idtable_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_idtable_a.namesum(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