how to show only even or odd rows in sql server 2008

Question

i have a table MEN in sql server 2008 that contain 150 rows   how i can show only the even or only the odd rows    thank s in advance

User · Answer

select   from Tablename  where id 2 0

User · Answer

Here   s a simple and straightforward answer to your question   I think    I am using the TSQL2012 sample database and I am returning only even or odd rows based on    employeeID    in the    HR Employees    table   USE TSQL2012  GO   Return only Even numbers of the employeeID   SELECT   FROM HR Employees WHERE  empid   2    0  GO   Return only Odd numbers of the employeeID   SELECT   FROM HR Employees WHERE  empid   2    1  GO   Hopefully  that   s the answer you were looking for

User · Answer

To fetch even records  select   from  select id row number   over  order by id  as r from table name  T where mod r 2  0    To fetch odd records  select   from  select id row number   over  order by id  as r from table name  T where mod r 2  1

User · Answer

odd number query   SELECT     FROM     SELECT rownum rn  empno  ename            FROM emp            temp   WHERE  MOD temp rn 2    1   even number query   SELECT     FROM     SELECT rownum rn  empno  ename            FROM emp            temp   WHERE  MOD temp rn 3    0

User · Answer

for SQL   odd   select   from id in select id from employee where id 2 1    for SQL   Even   select   from id in select id from employee where id 2 0      f5

User · Answer

Check out ROW NUMBER    SELECT t First  t Last FROM       SELECT    Row Number   OVER ORDER BY First  Last  AS RowNumber              --Row Number   starts with 1     FROM Table1   t WHERE t RowNumber   2   0 --Even --WHERE t RowNumber   2   1 --Odd

User · Answer

To select an odd id from a table   select   from Table Name where id 2 1    To select an even id from a table   select   from Table Name where id 2 0

User · Answer

SELECT   FROM  SELECT ROW NUMBER    OVER  ORDER BY sal DESC  row number  sr sal FROM empsal  a WHERE  row number 2    1   and         SELECT   FROM  SELECT ROW NUMBER    OVER  ORDER BY sal DESC  row number  sr sal FROM   empsal  a WHERE  row number 2    0

User · Answer

For even values record    select   from www where mod salary 2  0    For odd values record   select   from www where mod salary 2   0

User · Answer

Following is for fetching even number   Select   from MEN where Men ID 2 0   Following is for fetching odd number   Select   from MEN where Men ID 2  0   Here MEN is your table name Men ID is the column in MEN Table

User · Answer

SELECT     FROM              SELECT rownum rn  empno  ename      FROM emp     temp   WHERE  MOD temp rn 2    1

User · Answer

FASTER  Bitwise instead of modulus   select   from MEN where  id amp 1  0    Random question  Do you actually use uppercase table names  Usually uppercase is reserved for keywords   By convention

User · Answer

Try this    odd    select   from   SELECT col1  col2  ROW NUMBER   OVER ORDER BY col1 DESC  AS  RowNumber    FROM table1   d where  RowNumber   2    1    even    select   from   SELECT col1  col2  ROW NUMBER   OVER ORDER BY col1 DESC  AS  RowNumber    FROM table1   d where  RowNumber   2    0

User · Answer

Oracle Database  ODD ROWS  select   from  select mod rownum 2  as num   employees   from employees  where num  0    EVEN ROWS  select   from  select mod rownum 2  as num   employees   from employees  where num  1

User · Answer

Assuming your table has auto-numbered field  RowID  and you want to select only records where RowID is even or odd   To show odd   Select   from MEN where  RowID   2    1   To show even   Select   from MEN where  RowID   2    0

User · Answer

Try following   SELECT   FROM Worker WHERE MOD  WORKER ID  2   lt  gt  0

[sql-server-2008] how to show only even or odd rows in sql server 2008?

Examples related to sql-server-2008