/SQL/Mysql select top 2

Mysql select top 2

Mysql select top 2

SELECT x,y 
FROM z 
LIMIT 0,2;
// the first value in limit corresponds to start index, 
// the second value is the number of records to show

0

Source: grepper.com

Similar codes

0 vote64 views1 answer
Apt install sql server
SQL
2 votes68 views1 answer
Cannot return non-composite value from function that returns composite type
SQL
0 vote53 views1 answer
Initcap in mysql
SQL
2 votes55 views2 answers
Mysql show table column comments sql
SQL
0 vote54 views1 answer
Drop domain postgresql
SQL
0 vote48 views1 answer
Drop all triggers oracle
SQL
0 vote51 views1 answer
Oracle query to see what scema i am working in
SQL
0 vote53 views1 answer
Mysql grant access to one database
SQL
0 vote53 views1 answer
Compare subqueries oracle
SQL
10 votes60 views5 answers
Mysql create user
SQL

Share