-
Selecting two random (different)column values - seems tricky
A table has two columns - firstname & lastname
Now, I want to randomly select a firstname and lastname.
The trick is, the firstname and lastname must NOT be selected from same row!
I tried to use dbms_random.value(1,1000) and got the names, the problem is how do I concat the two fields
If I use
select firstname, lastname from customer where....
then I get values from same row!
Thanks
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
|