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
14097 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

What is the difference between inner join and equi join?

1044

What are the different authentication modes in sql server? How can it be changed?

1142

What is an inner join?

1042

Explain what are the authentication modes in sql server?

1073

Is sql server is free?

1017

What is the difference between DataRow.Delete() and DataRow.Remove()?

1279

What is index fragmentation in ms sql server?

1148

Can we write ddl in trigger?

972

What is normalization and denormalization in sql server?

1065

List some major differences between triggers and stored procedures?

980

What is BCP? When does it used in sql server 2012?

1108

what is the system function to get current user's user id? : Sql server database administration

1050

What is the difference between Triggers and Stored Procedure?

1157

Explain transaction isolation levels in sql server?

1186

Do you know what are the restrictions that views have to follow?

1130