[Solved] SQL Query SELECT RECORDS

Question

for get the first 100 records for a table we use the limit clause. See the following Example.

Question: Get the first 100 persons that his name is starting for John

Answer: Select * from pearson where name like ‘John%’ limit 100

Accepted Answer

for get the first 100 records for a table we use the limit clause. See the following Example.

Question: Get the first 100 persons that his name is starting for John

Answer: Select * from pearson where name like ‘John%’ limit 100