You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@metamodel.apache.org by "Ashish Pancholi (JIRA)" <ji...@apache.org> on 2018/09/03 11:41:00 UTC

[jira] [Created] (METAMODEL-1195) how to select a random record or row from a database table

Ashish Pancholi created METAMODEL-1195:
------------------------------------------

             Summary: how to select a random record or row from a database table
                 Key: METAMODEL-1195
                 URL: https://issues.apache.org/jira/browse/METAMODEL-1195
             Project: Apache MetaModel
          Issue Type: Bug
            Reporter: Ashish Pancholi


I would like to select the random records from a table using Apache Metamodel, for example:

*SELECT* * *FROM* table *ORDER BY* NEWID() ** 

*OR*

*SELECT* *** *FROM* ** table ** *ORDER BY* DBMS_RANDOM.VALUE

 

Please let me know how to run this above query using Apache Metamodel.

 

Thank You.

** ** **



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)