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