row-value-expression Questions
3
Solved
Trying the same as this question but in SQLite. In my application I need to do this type of query:
SELECT First, Last, Score
FROM mytable
WHERE
('John', 'Jordan', 5) <= (First, Last, Score )
A...
Cranach asked 18/4, 2011 at 5:20
9
Solved
I have a table containing the fields group_id and group_type and I want to query the table for all the records having any tuple (group id, group type) from a list of tuples. For example, I want to ...
Aundreaaunson asked 4/11, 2011 at 9:2
3
Solved
Given a database like this:
BEGIN TRANSACTION;
CREATE TABLE aTable (
a STRING,
b STRING
);
INSERT INTO aTable VALUES('one','two');
INSERT INTO aTable VALUES('one','three');
CREATE TABLE anothe...
Irfan asked 25/9, 2009 at 1:11
5
Solved
Say you have Accounts table where ID column is PK and TaxID+AccountNumber is unique constraint:
select * from Accounts where ID in (100, 101)
now you want to make similar query using the natural...
Gelb asked 18/1, 2012 at 22:49
3
Solved
I'm doing a bunch of sum queries:
SELECT col1 + col2 + col3 + ...
Some of the values in some of the columns are null. I'm checking for them by doing:
SELECT CASE WHEN col1 is not null and col2 is ...
Unite asked 12/3, 2012 at 19:16
2
Solved
In my current application, I need to be able to do this type of query:
SELECT MIN((colA, colB, colC))
FROM mytable
WHERE (colA, colB, colC) BETWEEN (200, 'B', 'C') AND (1000, 'E', 'F')
and get ...
Selfsupport asked 31/3, 2011 at 21:47
4
Solved
Is it possible to compare tuples (thanks, a_horse_with_no_name) in the WHERE clause of a SQL query? That way, I could convert this:
/* This is actually a sub-sub-sub-query in the middle *
* of an...
Collaborative asked 4/2, 2011 at 16:34
2
Solved
I have the following table in a SQLite3 database:
CREATE TABLE overlap_results (
neighbors_of_annotation varchar(20),
other_annotation varchar(20),
set1_size INTEGER,
set2_size INTEGER,
jaccard RE...
Scanty asked 8/4, 2010 at 1:22
1
© 2022 - 2024 — McMap. All rights reserved.