w3resource

SQLite Exercise: Select first 10 records from a table

Write a query to select first 10 records from a table.

Note : Assume the salary field provides the 'annual salary' information.

Sample table : employees


SQLite Code :

SELECT employee_id, first_name 
FROM employees  
LIMIT 10;

Output:

employee_id  first_name
-----------  ----------
100          Steven
101          Neena
102          Lex
103          Alexander
104          Bruce
105          David
106          Valli
107          Diana
108          Nancy
109          Daniel

Practice SQLite Online


Model Database

Employee Model  Database - w3resource online SQLite practice

Structure of 'hr' database :

hr database

Improve this sample solution and post your code through Disqus.

Previous: Write a query to get the length of the employee names (first_name, last_name) from employees table.
Next: Write a query to get monthly salary (round 2 decimal places) of each and every employee?

What is the difficulty level of this exercise?



Share this Tutorial / Exercise on : Facebook and Twitter