Search This Blog
Thursday, August 11, 2011
In table we have no identity number then create row id in table run time
SELECT t.* FROM (SELECT *, Row_Number() OVER(ORDER BY userid) AS RowNumber FROM table_user) t WHERE t.RowNumber % 2 = 0
Tuesday, August 9, 2011
select data in 2 part by even and odd data selection by sql query
select * from help where (SNo%2)=0 //even case
select * from help where (SNo%2)<>0 //odd case
Subscribe to:
Posts
(
Atom
)