1 of 1 people found this helpful
Whether or not a Custom SQL statement is valid is completely dependent on the syntax of the data source you are querying. You could try and build something against your database directly and then see if the same SQL works from Tableau as Custom SQL.
Yes you are right. Query syntax was wrong.
Actually i had worked on mysql and LIMIT works in mysql.
but Now i am using oracle database . Oracle doesn't support LIMIT.
Correct Syntax : select * from(select * from temp order by a asc) where rownum<=3