0
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.
4 Antworten
+ 2
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
0
Yeah its true
0
yes . oracle doesn't support limit
0
You are right.