vendredi 20 mars 2020

How to get sample rows from a view in Sybase IQ

I am trying to get a sample data from a view in Sybase IQ 16.

To get sample data from a table I used the below query and it works fine for a table.

SELECT * FROM table1 WHERE RAND(ROWID(table1)) < .05;

However, when trying to get data from a view< i am getting below error.

SQL Anywhere Error -1113: Correlation name 'view_name' is not valid for use with the ROWID function

Please suggest.




Aucun commentaire:

Enregistrer un commentaire