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
- 13831 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
How are the exceptions handled in sql server programming?
What is single-user mode?
What is view in sql?
Explain what are commit and rollback in sql?
How to use the inserted and deleted pseudo tables?
Why is the need for data conversion transformations?
Which are the two editions in which SQL Azure database available?
What is format parameter in ssrs?
How to rename an existing column with sql server management studio?
Can primary key be null?
What is the full form of dql?
What options are available to audit login activity? : sql server security
How to list all login names on the ms sql server?
How are the unique and primary key constraints different?
What is the use of attributehierarchyvisible ? : sql server analysis services, ssas
