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
- 13556 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 triggers? How do you invoke a trigger on demand?
How to disable triggers using "disable trigger"?
Does partitioning ssd reduce performance?
What is the difference between stored procedure and user defined functions?
What is user defined stored procedures?
What are the encryption mechanisms in sql server?
How to scale out a federation by Sql statement?
What is a mutating table error and how can you get around it?
Difference between aggregate functions of sql?
can you implement data mining in SSRS?
How to create an inline table-valued function?
Is BCNF better than 2NF & 3NF? Why?
How to create a view on an existing table in ms sql server?
How to define and use table alias names in ms sql server?
Why Master database is required?
