hide 0 in rows of sql query

update all zero to null and try this

select coalesce(samiksha,sharad,sac) as samiksha , coalesce(samiksha,sharad,sac) as sharad ,coalesce(samiksha,sharad,sac) as sac from table

accept it if it works for you.

If you want only 1. row

SELECT samiksha, sharad, sac	
FROM TableName
WHERE sharad <> 0 AND sac <> 0

or
if you want only 2. row

SELECT samiksha, sharad, sac	
FROM TableName
WHERE samiksha <> 0

[EDIT]

DECLARE @tmp TABLE (samiksha INT, sharad INT, sac INT)

INSERT INTO @tmp (samiksha,sharad,sac)
    VALUES(0, 10, 0), (1, 0, 0)


SELECT samiksha, sharad, sac
FROM @tmp
WHERE sharad <> 0 AND sac <> 0

SELECT samiksha, sharad, sac
FROM @tmp
WHERE samiksha <> 0

SELECT SUM(samiksha) AS samiksha, SUM(sharad) AS sharad, SUM(sac) AS sac
FROM @tmp

Returned values:
1. query

(none)

2. query

1	0	0

3. query

1	10	0

[/EDIT]

select * ,row_number() over(order by sac asc) as rowid into #temp from sql table

select * from #temp where rowid not in(1)

now try it