Welcome to plsql4all.blogspot.com SQL, MYSQL, ORACLE, TERADATA, MONGODB, MARIADB, GREENPLUM, DB2, POSTGRESQL.

Sunday, 24 May 2015

How to Fetch Sample Records From MySql Database

We can fetch sample records from MySql database by using LIMIT clause and the end of the query.

The basic syntax is:-

SELECT * FROM TABLE_NAME LIMIT ]NUMBER]

Example can be:-

SELECT * FROM EMPLOYEES LIMIT 5;
Please provide your feedback in the comments section above. Please don't forget to follow.