On 8/6/2012 9:24 AM, Rob Richardson wrote:
Which of those would be fastest? Or don't you have enough information to tell?
Hard for me to predict. If it were important to me, I'd test and time
all of them on a realistic dataset.
--
Igor Tandetnik
_
Subject: Re: [sqlite] Select rows where a column is not unique
On Mon, Aug 6, 2012 at 2:58 PM, Tilsley, Jerry M.
wrote:
> Guys,
>
> I'm sure this is a pretty lame question, but my thinking hat is
> malfunctioning this morning. How can I select all rows from a table
> where
e.org
Subject: Re: [sqlite] Select rows where a column is not unique
Tilsley, Jerry M. wrote:
> I'm sure this is a pretty lame question, but my thinking hat is
> malfunctioning this morning. How can I select all rows from a table where a
> specific column is NOT UNIQUE?
select *
On Mon, Aug 6, 2012 at 2:58 PM, Tilsley, Jerry M.
wrote:
> Guys,
>
> I'm sure this is a pretty lame question, but my thinking hat is
> malfunctioning this morning. How can I select all rows from a table where
> a specific column is NOT UNIQUE? Table has three columns (charge_code,
> mnemonic, de
Tilsley, Jerry M. wrote:
> I'm sure this is a pretty lame question, but my thinking hat is
> malfunctioning this morning. How can I select all rows from a
> table where a specific column is NOT UNIQUE?
select * from MyTable where SpecificColumn in (
select SpecificColumn from MyTable
group
Guys,
I'm sure this is a pretty lame question, but my thinking hat is malfunctioning
this morning. How can I select all rows from a table where a specific column
is NOT UNIQUE? Table has three columns (charge_code, mnemonic, description).
Thanks,
Jerry Tilsley
Sr Systems Analyst
St. Claire
6 matches
Mail list logo