Which two statements are valid uses of the LIMIT clause?

A table country exists with a column Name. A user variable @ limitcount contains the value
20.
Which two statements are valid uses of the LIMIT clause?

A table country exists with a column Name. A user variable @ limitcount contains the value
20.
Which two statements are valid uses of the LIMIT clause?

A.
SELECT Name FROM country LIMIT 100-50

B.
SELECT Name FROM country LIMIT 100,50

C.
SELECT Name FROM country LIMIT 35

D.
SELECT Name FROM country LIMIT @limitcount

E.
SELECT Name FROM country LIMIT RAND ()



Leave a Reply 2

Your email address will not be published. Required fields are marked *


zz

zz

B and C

user variable is not supported in limit