how to retriave first row,third row,fifth row and so on

Have you tried anything yet ?

your question is not completely clear what exactly you want to retrieve?

For get odd rows :

WITH Table2 AS
(
SELECT Col1,Col2,
ROW_NUMBER() OVER (ORDER BY Col2 ) AS 'RowNo'
FROM Table1
)
SELECT Col1,Col2
FROM Table2
WHERE RowNo % 2 <> 0 ;


-----------------OR--------------------
You can also try

Select Col1,Col2
from Table1
where (( ROW_NUMBER() OVER (ORDER BY Col2 ) ) % 2 ) <> 0



Key point is ROW_NUMBER() function .

hi
I am working on a online teaching website where I need to add a chating option and a white board for drawing purpose by which a teacher can teach to a student. So please guide me how I can Add these two things on my web site?
please reply soon.........

Please send your questions in proper thread, this thread is only for sql server .

For a temporary soln - : use
select * from
(select row_number() row_no, emp_no from employee ) emp
where row_no%2<>0;

Hope this works