Sometimes sql query depends upon database used...for example oracle does not support LIMIT clause whereas mySQL does.Is it true??correct me if i am wrong.

Answer 1

Hi guys
regarding Oracle: yes, you are right, until 11gR2 there was no limit clause though there are "workarounds" (say: other syntax) to solve this problem.
But with release 12cR1 Oracle introduced the limit and the fetch syntax to make life easier for Top-N queries. For instance, check it out here:
https://oracle-base.com/articles/12c/row-limiting-clause-for-top-n-queries-12cr1

Answer 2

Yeah its true

Answer 3

yes . oracle doesn't support limit

Answer 4

You are right.