SQLite SELECT

1 개요

SQLite SELECT

SELECT * FROM employees LIMIT 3;

SELECT EmployeeId, LastName, FirstName FROM employees LIMIT 3;

SELECT * FROM invoices LIMIT 3;

SELECT InvoiceId, CustomerId, InvoiceDate, BillingAddress, BillingCountry FROM invoices WHERE BillingCountry='Spain';

2 같이 보기

• SQLite PRAGMA TABLE_INFO()
• SQLite DELETE
• SQLite UPDATE
• SQLite INSERT
• SELECT