.
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;
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)
Please provide your feedback in the comments section above. Please don't forget to follow.