NEW INTERVIEW QUESTIONS.COM
ORACLE INTERVIEW QUESTIONS
SQL IN ORACLE INTERVIEW QUESTIONS DETAILS
NewInterviewQuestions.com - Home for World's Largest Interview Questions Website.
A D V E R T I S E M E N T
||Displaying EVERY 4th row in a table : (If a table has 14 rows, 4,8,12
rows will be selected)
select * from
( select COL_NAME1,COL_NAME2,row_number() over(order by PRIMARY_KEYCOL Desc)new_tab from TABLE_NAME)
Answered By: Manikandan Date: 8/28/2008
If you have the better answer, than send it to us. We will display your answer after the approval.
Rate the above answer. Help us to know about the answer.
Please Note: We keep on updating better answers to this site. Subscribe to our newsletter to get notified when better answer is posted.
|Notify me when answer is posted!