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.

9th Sep 2016, 8:01 AM
Vipul Newaskar
Vipul Newaskar - avatar
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
9th Sep 2016, 11:47 AM
Stephan Borsodi
Stephan Borsodi - avatar
0
Yeah its true
9th Sep 2016, 9:43 AM
Kirtiranjan Sahoo
Kirtiranjan Sahoo - avatar
0
yes . oracle doesn't support limit
9th Sep 2016, 9:48 AM
sangamesh naikar
sangamesh naikar - avatar
0
You are right.
9th Sep 2016, 4:35 PM
plain
plain - avatar