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
- 13563 Views
- ADP, Satyam, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / vijayplsql@gmail.com
For 1,3,5,7...
select * from emp where (rowid,1) in (select rowid,mod
(rownum,2) from emp);
For 2,4,6,8,...
select * from emp where (rowid,0) in (select rowid,mod
(rownum,2) from emp);
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
how to define testing of network layers? : Sql server database administration
What is the advantage of sql server?
What do you mean by data integrity?
How to update muliple row in single query?
Explain important index characteristics?
What are the 2 types of classifications of constraints in the sql server?
Who is the owner of a schema in ms sql server?
What is use of attribute hierarchy optimized state? : sql server analysis services, ssas
What is an expression in ms sql server?
How to turn off warning messages during php execution?
How many types of attribute relationships are there? : sql server analysis services, ssas
hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.
What is the difference between stored procedure and user defined functions?
What is dbcc command in sql server?
What is a derived table?
