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
- 14109 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 to use linked server?
What are the advantages of paper records?
what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
Relational calculus is what type of language?
Explain four layers of abstraction microsoft architectured?
What are views in ms sql server?
what is a schema in sql server 2005? : Sql server database administration
How do you set a trace flag in sql server?
What happens when converting big values to numeric data types?
Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?
Explain about SQLOS?
What are the limitations/drawbacks or ssrs 2008 r2?
What is tcl in sql server?
How to update values in a table with update statements in ms sql server?
What are the database roles? : sql server security
