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
- 11859 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
Determine when an index is appropriate?
what is the difference between a primary key and a unique key? : Sql server database administration
How do you make a trace?
What do you mean by data integrity?
Explain what is meant by replication of database?
Explain identity in sql server?
What is the importance of a recovery model?
Why would you use sql agent?
Do you think BCNF is better than 2NF & 3NF? Why?
Explain how to use linked server?
What are the differences between lost updates and uncommitted dependencies?
What is ssl in sql server?
How many types of stored procedures are there in sql server?
How to create a large table with random data for index testing in ms sql server?
What are the different types of backups avaialabe in sql server 2005?
