summaryrefslogtreecommitdiff
path: root/test/scanners/sql/selects.in.sql
diff options
context:
space:
mode:
Diffstat (limited to 'test/scanners/sql/selects.in.sql')
-rw-r--r--test/scanners/sql/selects.in.sql46
1 files changed, 0 insertions, 46 deletions
diff --git a/test/scanners/sql/selects.in.sql b/test/scanners/sql/selects.in.sql
deleted file mode 100644
index 3c6203f..0000000
--- a/test/scanners/sql/selects.in.sql
+++ /dev/null
@@ -1,46 +0,0 @@
---RANDOM SQL QUERIES THAT DO NOTHING INTERESTING
---Copyright (C) 2009 - Keith Pitt <keith@keithpitt.com>
-
---This program is free software: you can redistribute it and/or modify
---it under the terms of the GNU General Public License as published by
---the Free Software Foundation, either version 3 of the License, or
---(at your option) any later version.
-
---This program is distributed in the hope that it will be useful,
---but WITHOUT ANY WARRANTY; without even the implied warranty of
---MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
---GNU General Public License for more details.
-
---You should have received a copy of the GNU General Public License
---along with this program. If not, see <http://www.gnu.org/licenses/>.
-
-SELECT * FROM users;
-
-select * from users;
-
-SELECT `First Name`, `Last Name` FROM `User Table`;
-
-select first_name, last_name FROM users;
-
-select first_name || ' ' || last_name from users;
-
-select first_name || " " || last_name from users;
-
-SELECT * FROM users JOIN companies USING (company_id) WHERE company_type = 'Fortune 500';
-
-SELECT * FROM users WHERE name_first LIKE '%Keith%';
-
-SELECT CASE WHEN foo.bar = 'PY'
- THEN 'BAR'
- ELSE 'FOO'
- END as bar_type,
- user_id,
- company_id,
- sum(
- case when foo.bar = 'PY'
- then -amt else amt
- end
- ) over (order by id, amt) as balance;
-
-SELECT users.*, (SELECT company_name FROM companies WHERE company_id = users.company_id) FROM users;
-