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