SELECT ROW_NUMBER()OVER(order by no) , no FROM fallacy order by no desc
'DATABASE' 카테고리의 다른 글
| [Oracle] ROW_NUMBER()OVER( ) (0) | 2008.03.11 |
|---|---|
| [Oracle ] Sequence (0) | 2008.03.11 |
| [Oracle ] Sequence (0) | 2008.03.11 |
DATABASE
[Oracle] ROW_NUMBER()OVER( )
SELECT ROW_NUMBER()OVER(order by no) , no FROM fallacy order by no desc