The SELECT Clause
Siim Kinks edited this page Mar 21, 2017
·
4 revisions
The SELECT
clause is the starting point to query builder API.
SQL | SqliteMagic |
---|---|
SELECT BOOK.ID, BOOK.TITLE
SELECT BOOK.ID, upper(BOOK.TITLE) |
import static com.siimkinks.sqlitemagic.BookTable.BOOK;
import static com.siimkinks.sqlitemagic.Select.upper;
Columns columns1 = Select.column(BOOK.ID, BOOK.TITLE);
Columns columns2 = Select.column(BOOK.ID, upper(BOOK.TITLE)); |
The distinct
method can be used to define a DISTINCT
keyword. In the resulting query duplicate rows are moved from the set of result rows. For the purposes of detecting duplicate rows, two NULL values are considered to be equal.
SQL | SqliteMagic |
---|---|
SELECT DISTINCT BOOK.TITLE
SELECT DISTINCT BOOK.TITLE, BOOK.SUB_TITLE
SELECT DISTINCT *
|
import static com.siimkinks.sqlitemagic.BookTable.BOOK;
SingleColumn<String> column = Select.distinct(BOOK.TITLE);
Columns columns1 = Select.distinct(BOOK.TITLE, BOOK.SUB_TITLE);
Columns columns2 = Select.distinct(); |