How do you return the a hundred books starting f

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

How do you return the a hundred books starting from 25th?

SELECT book_title FROM books LIMIT 25, 100. The first number in LIMIT is the offset, the second is the number.

(Continued on next question...)

Other Job Interview Questions

• MySQL is Portability
• Explain data type TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
• How would you delete a column?
• MySQL - Startup options to mysqld which concerns security
• But what if you really want to store the timestamp data, such as the publication date of the article?
• How do you find out which auto increment was assigned on the last insert?
• MySQL - General Security
• Explain the difference between MyISAM Static and MyISAM Dynamic.
• How would you write a query to select all teams that won either 2, 4, 6 or 8 games?
• Functionality Missing from MySQL - SELECT INTO TABLE
• More...