For: 2, 4, 6, ...... select * from <Table_Name> where <Column

how to write the query to select the rows are in the order
of either 1,3,5,7... or 2,4,6,8,...

Question Posted / md. niyaz

7 Answers
13822 Views
ADP, Satyam, Tech Mahindra, I also Faced
E-Mail Answers

Answer Posted / md. niyaz

For: 2, 4, 6, ......

select * from <Table_Name> where <Column_Name> % 2 = 0

==============Niyaz====================================

For: 1, 3, 5, ......

select * from <Table_Name> where <Column_Name> % 2 = 1

Is This Answer Correct ?

3 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

how many bits ip address consist of? : Sql server database administration

898

How will you find out if there are expensive SQL statements running or not?

1010

What are the mathematical functions supported by sql server 2005?

1063

What is the difference RDBMS and Graph Database?

1045

What are the differences between ms sql server & oracle?

1056

Write an sql query to find first weekday of the month?

912

Can a cursor be updated? If yes, how you can protect which columns are updated?

1102

What will be the maximum number of indexes per table?

956

how many clustered indexes can be created on a table? : Sql server database administration

1145

You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?

121

When is the use of update_statistics command?

998

What is the contrast between sql and pl/sql?

1141

What are the differences between stored procedure and view in sql server?

1244

How do I start sql server?

966

How to disconnect from a sql server using mssql_close()?

1104