| require output in described order [message #638786] |
Sun, 21 June 2015 03:20  |
 |
jgjeetu
Messages: 373 Registered: July 2013 Location: www.Orafaq.com/Forum
|
Senior Member |

|
|
>create table test(gender varchar2(1))
>insert into test values('M');
>insert into test values('M');
>insert into test values('M');
>insert into test values('M');
>insert into test values('F');
>insert into test values('F');
>insert into test values('F');
>
output:-
gender
M
M
M
M
F
F
F
required output is:-
gender
M
F
M
F
M
F
M
[Updated on: Sun, 21 June 2015 03:25] Report message to a moderator
|
|
|
|
|
|
| Re: require output in described order [message #638788 is a reply to message #638787] |
Sun, 21 June 2015 05:13   |
 |
Michel Cadot
Messages: 68776 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
When ORDER BY is useless/meaningless in an analytical function I prefer to use ORDER BY NULL which prevents from questions like "why ORDER BY ROWNUM?" or "what is the meaning of ORDER BY ROWNUM?" (which will be hard to explain how it works).
Edit: English
[Updated on: Sun, 21 June 2015 14:30] Report message to a moderator
|
|
|
|
|
|