Answer Posted / Swati Chandra
In Oracle, you can use the analytic functions like ROW_NUMBER() OVER (ORDER BY column_name) to assign a row number to each row in your result set and then use it to group the rows. Here is an example: SELECT * FROM (SELECT column1, column2, ROW_NUMBER() OVER(ORDER BY column_name) as row_num FROM table_name) WHERE row_num % n = 0; This will divide your output into groups of n rows.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to write a left outer join with the where clause in oracle?
Design database draw er diagram for a certain scenario ?
How to use values from other tables in update statements using oracle?
How to start an oracle instance?
How to put more than 1000 values into an oracle in clause?
How to select all columns of all rows from a table in oracle?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
What is oracle latest version?
