VINAY KUMAR

VINAY KUMAR

  • 1.7k
  • 92
  • 63.2k

search only single record

Mar 15 2017 11:02 AM
  1. select table_a.Student_id,table_a.name,sum(table_b.amount) from table_a left outerjoin
  2. 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"

Answers (4)