sql - Count number of rows in a table for a student -

i have table named summary. want write query find out student has @ least 1 row in table summary. how find it?

name subject mark abc  english  100 abc  tamil    100 def  tamil    100 ghi  french   100 ghi  science  100 ghi  social   100 

count gives number of rows. need select student has atleast 1 row

use group , count:

select name, count(*) summary group name 

or, if need student abc:

select count(*) summary name = 'abc'