hide 0 in rows of sql query

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]

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.

select j.`samiksha` ,j1.`sharad`,j2.`sac`  AS sac
FROM tablename j
LEFT JOIN tablename j1 ON j1.`sharad` <> 0
LEFT JOIN tablename j2  ON j2.`sac` <> 0
WHERE j.samiksha <> 0;

just use join on that table...u will get result what u want.

This is working ............try it reply me.....