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
- 11904 Views
- ADP, Satyam, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / tiru
select * from
(select emp.ename, emp.age, (rownum+1) AS XX from employee
emp )
where remainder(XX,2) = 0;
select * from
(select emp.ename, emp.age, (rownum+1) AS XX from employee
emp )
where remainder(XX,2) = 1;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are two difference between sql azure and azure tables?
Explain the purpose of indexes?
What are character string data types in ms sql server?
What are the character string functions supported by sql server 2005?
what stored procedure can you use to display the current processes? : Sql server administration
What is ssrs?
What are the differences between ms sql server & oracle?
What are the different types of replication you can set up in sql server?
Explain “row_number()” in sql server with an example?
How to invoke a trigger on demand?
How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?
What is clr ddl trigger?
Do you know the capabilities of cursors?
Explain different types of self contained sub query?
How to create an identity column?
