#DateForumTypeThreadPost
309 Jan 2010 @ 01:44 PSTConnectivityTopicany limitations with large number (10,000) parameters to sql SELECT via JDBC?I need to query on up to 10,000 different values :SELECT * from MYTABLE where COL1=? OR COL1=? OR COL1=? ...Is there a maximum number of parameters that can be passed, or a maximum length to the q...
214 Jun 2007 @ 09:10 PDTDatabaseReplyGROUP BY and WITH...BY clauses may not contain aggregate functions ?Thanks very much for your response - that explains it.There is a subtle difference between GROUP BY and leaving off the GROUP BY. If I leave off the GROUP BY, when there are no matching rows, t...
113 Jun 2007 @ 06:21 PDTDatabaseTopicGROUP BY and WITH...BY clauses may not contain aggregate functions ?I execute the SQL below and I get the error message. There no is aggregate in the 'GROUP BY' clause as the message claims. The SQL works fine on Oracle and other databases.SELECT COUNT(*) AS c1 ...