SyntaxFix

[sqlite] How to get Top 5 records in SqLite? 

select price from mobile_sales_details order by price desc limit 5

Note: i have mobile_sales_details table

syntax

select column_name from table_name order by column_name desc limit size.

if you need top low price just remove the keyword desc from order by

Examples related to sqlite

• getting " (1) no such column: _id10 " error • Laravel: PDOException: could not find driver • auto create database in Entity Framework Core • How to open .SQLite files • Accessing an SQLite Database in Swift • When does SQLiteOpenHelper onCreate() / onUpgrade() run? • Attempt to write a readonly database - Django w/ SELinux error • Android sqlite how to check if a record exists • How can I add the sqlite3 module to Python? • "Insert if not exists" statement in SQLite

Examples related to select

• Warning: Use the 'defaultValue' or 'value' props on <select> instead of setting 'selected' on <option> • SQL query to check if a name begins and ends with a vowel • Angular2 *ngFor in select list, set active based on string from object • SQL: Two select statements in one query • How to get selected value of a dropdown menu in ReactJS • DATEDIFF function in Oracle • How to filter an array of objects based on values in an inner array with jq? • Select unique values with 'select' function in 'dplyr' library • how to set select element as readonly ('disabled' doesnt pass select value on server) • Trying to use INNER JOIN and GROUP BY SQL with SUM Function, Not Working