"SQLite SELECT"의 두 판 사이의 차이

2021년 1월 24일 (일) 12:23 기준 최신판

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';

@@ 3번째 줄: / 3번째 줄: @@
 <syntaxhighlight lang='sqlite3' run>
-SELECT * FROM employees;
+SELECT * FROM employees LIMIT 3;
 </syntaxhighlight>
 <syntaxhighlight lang='sqlite3' run>
-PRAGMA table_info(employees);
+SELECT EmployeeId, LastName, FirstName FROM employees LIMIT 3;
+</syntaxhighlight>
+<syntaxhighlight lang='sqlite3' run>
+SELECT * FROM invoices LIMIT 3;
+</syntaxhighlight>
+<syntaxhighlight lang='sqlite3' run>
+SELECT InvoiceId, CustomerId, InvoiceDate, BillingAddress, BillingCountry FROM invoices WHERE BillingCountry='Spain';
 </syntaxhighlight>
 ==같이 보기==
+* [[SQLite PRAGMA TABLE_INFO()]]
 * [[SQLite DELETE]]
 * [[SQLite UPDATE]]