¡Nuevo curso! ¡Todo programador debería aprender IA Generativa!
Prueba una lección gratuita0
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 Respuestas
+ 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.