Menu
If the primary keys of the records are 1,3,4,5,6,8
I want to select the records with pk:1,6
NOTE
I don't know which ids are non-consecutive
247
The following is the syntax to get the last 10 records from the table. Here, we have used LIMIT clause. SELECT * FROM ( SELECT * FROM yourTableName ORDER BY id DESC LIMIT 10 )Var1 ORDER BY id ASC; Let us now implement the above query.
To select rows using selection symbols for character or graphic data, use the LIKE keyword in a WHERE clause, and the underscore and percent sign as selection symbols. You can create multiple row conditions, and use the AND, OR, or IN keywords to connect the conditions.
Select the header or the first row of your list and press Shift + Ctrl + ↓(the drop down button), then the list has been selected except the first row. Note: If there are blank cells in your list, it will select the list until the first blank cell appears with this method.
Or click on any cell in the column and then press Ctrl + Space. Select the row number to select the entire row. Or click on any cell in the row and then press Shift + Space. To select non-adjacent rows or columns, hold Ctrl and select the row or column numbers.
SELECT *
FROM your_table AS a
LEFT JOIN your_table AS b
ON a.key_column = b.key_column - 1
WHERE b.key_column IS NULL
Why not use a where clause in your SQL query ?
select *
from your_table
where id in (1, 6)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
