Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-02-14 : 09:00:07
|
| Srikanth Karamboor writes "I would like to know how will we display the data present only in the odd rows of a table leaving out the even rows." |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-02-14 : 09:15:30
|
| How do you determine whether its odd or even?Rows returning from a table are not sorted if v do not sort it purposely.What is your final requirement?Give some sample data, and the results u want to get. |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-02-14 : 09:15:38
|
| Why do you want to do this?You need to define the Odd and Even rowsOne of the ways is to use keycolumn(identity or primary)Select columns from yourTable where identitycol%2=1MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
sql server 2000