Re: [sqlite] Sub-Select reports only row one value?

Igor Tandetnik was right on this. Thank you. > Scalar Subqueries > > A SELECT statement enclosed in parentheses may appear as a scalar > quantity. A SELECT used as a scalar quantity must return a result set > with a single column. The result of the expression is the value of the > only column

Re: [sqlite] Sub-Select reports only row one value?

Igor, Thank you for your consideration and reply. On 2/5/2011 11:12 AM, Igor Tandetnik wrote: > Jeff Hennick wrote: > When syntactically used as an expression (e.g. in SELECT clause), a subselect > produces a single value. When used as a table (e.g. in FROM clause), it may

Re: [sqlite] Sub-Select reports only row one value?

Jeff Hennick wrote: > I am having problems with Sub-Select apparently working on one row > rather than the whole table. When syntactically used as an expression (e.g. in SELECT clause), a subselect produces a single value. When used as a table (e.g. in FROM clause), it may

[sqlite] Sub-Select reports only row one value?

I am having problems with Sub-Select apparently working on one row rather than the whole table. registrations table: Class | Term | (Other student columns) CC123 | 101 | ... CC002 | 101 CC050 | 111 CC123 | 101 CC123 | 102 ... Desired ultimate output counts by class and term, with totals and

Re: [sqlite] Sub select problem

On Wed, 17 May 2006, Malk0 wrote: [...] BUT if i add a GROUP BY clause in the subselect the results returned in ct is just false ex: - doing SELECT count(*) FROM (SELECT * FROM mytable GROUP BY col1) _TMPTABLE_; return one row with 20 in ct and that's FALSE, this is the total amount of row in

[sqlite] Sub select problem

First of all i'm using Sqlite for 2 years now and just want to tell it's great! that's done and now here's why i'm sending this message to the list: I'm working on pagination and want to retrieve the number of row that i would normally retrieve without the Limit clause. So i hoped to use

Re: [sqlite] Sub-Select

Jakub Adamek schrieb: Michael, it is because SQLite 3.1.3 changed (or has errors in, it is a matter of opinion) the column naming. Try Thanks a lot - it works! Bye Michael

Re: [sqlite] Sub-Select

Michael, it is because SQLite 3.1.3 changed (or has errors in, it is a matter of opinion) the column naming. Try >> SELECT max(Sendung) >> FROM >> (SELECT S.Sendung AS Sendung >> FROM Auftrag AS A, >> Sendung AS S >> WHERE(A.PosyDat = 1 AND A.PosyDat = S.PosyDat) AND >>

Re: [sqlite] Sub-Select

Hi, sorry... I forgot I get the error "no such column: Sub.Sendung" So I guess/hope it's only a "syntax error" with my SQL - my SQL-Skills are rather bad ;-( Thanks, Michael All, could someone please tell me why this query doesn't work with 3.1.3 (with 3.0.8 it works): SELECT

[sqlite] Sub-Select

All, could someone please tell me why this query doesn't work with 3.1.3 (with 3.0.8 it works): SELECT max(Sub.Sendung) FROM (SELECT S.Sendung FROM Auftrag AS A, Sendung AS S WHERE(A.PosyDat = 1 AND A.PosyDat = S.PosyDat) AND (A.PosyNId = 6 AND A.PosyNId =