Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 13876 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
Explain different types of lock modes in sql server 2000?
what is a transaction? : Sql server database administration
How to check table values in sql server?
Explain the types of indexes.
What is CTE in SQL
What is cross join in sql server joins?
Explain how to maintain a fill factor in existing indexes?
How many triggers you can have on a table?
Do you know what are various aggregate functions that are available?
Can we create clustered index on composite key?
what is a join and explain different types of joins? : Sql server database administration
what is bit datatype? : Sql server database administration
How do I perform an unattended install of sql server 2000?
What is instead of dml trigger?
what is denormalization? : Sql server database administration
