-
retrieve records in disperse way
i am having a records like abcde, i know the way of executing them in ascending/descending,but how to retrieve the records in b,d,a,c like.
please help me out in this issue
-
Use a function from the DBMS_RANDOM package to assign a random integer to each row, then order by that random integer
-
can u please send that query
-
select c1, c2
from mytable
order by dbms_random.value;
Tamil
-
Originally Posted by krishnareddy
can u please send that query
Google down again huh?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|