search only single record

VINAY KUMAR

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

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"

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ramesh Palanivel9y ago
Accepted 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
Thennarasu N9y ago
1. /* 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 */
3. select table_a.Student_id,table_a.name,sum(table_b.amount) from table_a left outerjoin
4. table_b on table_a.Student_id=table_b.student_id where table_a.Student_Id =2
5. group by
6. table_a.Student_id
Nilesh Shah9y ago
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"
Tapan Patel9y ago
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
3. where table_a.Student_id=232
4. group by table_a.Student_id