how to write the query to select the rows are in the order
of either 1,3,5,7... or 2,4,6,8,...
- 7 Answers
- 11907 Views
- ADP, Satyam, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / vijay sultampur
For 1,3,5,7...
select * from emp where (rowid,1) in (select rowid,mod
(rownum,2) from emp);
For 2,4,6,8,...
select * from emp where (rowid,0) in (select rowid,mod
(rownum,2) from emp);
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Explain concepts of analysis services?
Can foreign key be deleted?
Can we install sql server 2016 on windows 7?
What is the process of indexing?
What is snapshot replication?
What is difference between index and primary key?
Does partitioning improve performance?
How to retrieve error messages using mssql_get_last_message()?
Tell me what is normalization? Explain different forms of normalization?
What are xml indexes?
explain different levels of normalization? : Sql server database administration
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
Explain about system database?
Why people hate cursor?
What does the automatic recovery do?
