MySQL first functionThe MySQL first function is used to return the first value of the selected column. Here, we use limit clause to select first record or more. Syntax: MySQL first function exampleTo SELECT FIRST element: Consider a table named "officers", having the following data. ![]() Execute the following query: Output: ![]() To SELECT FIRST two records Output: ![]()
Next TopicMySQL last
|
JavaTpoint offers too many high quality services. Mail us on [email protected], to get more information about given services.
JavaTpoint offers college campus training on Core Java, Advance Java, .Net, Android, Hadoop, PHP, Web Technology and Python. Please mail your requirement at [email protected]
Duration: 1 week to 2 week