Lines Matching refs:select

42       select * from records where type = 'D/D';
45       select strftime('%Y-%m', date) as date, (-1 * sum(value)) as value
51       select strftime('%Y-%m', date) as date, (-1 * sum(value)) as value
57       select strftime('%Y-%m', date) as date, (-1 * sum(value)) as value
65       select strftime('%Y-%m', date) as date, (-1 * sum(value)) as value
72       select 'Energy' as expense, date, value from energy
74       select 'Phone/Internet' as expense, date, value from phone_internet
76       select 'Credit Card' as expense, date, value from credit_cards;
79       select 'jan', expense, value from expense_overview
83       select 'nov', expense, value from expense_overview
87       select * from jan join nov on (jan.expense = nov.expense);
93     select * from summary;