Home / Programming MCQs / MySQL MCQs / Question
J
Q. Suppose you have 1000 records and you only want 100 records which of the following clause you will use?
The LIMIT clause helps us to set a limit to records we want in return as a result.
You must be Logged in to update hint/solution
What is the clause that filters JOIN results called?
What statement is used to show the definition of an existing database?
Which of the following returns the current value in a specified sequence.
How is communication established with MySQL?
Which command will remove the records from the table, but not affect the structure of the table?
How many distinct, different values can you hold in an enum field?
If no database has been selected, specifying a database qualifier is necessary.
Discusssion
Login to discuss.