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;

No comments:

Post a Comment

Please provide your feedback in the comments section above. Please don't forget to follow.