Does any know if there is a limitation on the number of items you can
contain within an SQL list. (e.g. WHERE id IN (,,,,) ). And if that
differs from having a sub-query oppose to literal values?
Regards,
Craig. 2 5377
Craig B. wrote: Does any know if there is a limitation on the number of items you can contain within an SQL list. (e.g. WHERE id IN (,,,,) ). And if that differs from having a sub-query oppose to literal values?
Regards, Craig.
Yes. At a certain point a subquery will be
easier to write, maintain and code.
--
Regards,
Frank van Bortel
999
"Craig B." <cr**********@practiceone.com> schreef in bericht
news:6a**************************@posting.google.c om... Does any know if there is a limitation on the number of items you can contain within an SQL list. (e.g. WHERE id IN (,,,,) ). And if that differs from having a sub-query oppose to literal values?
Regards, Craig. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Tamer Higazi |
last post by:
Hi!
I have problems creating joins between tables and to limit rows for a
specified clolumn. I have 2 tables!
employees
departments
I face the problems with the GROUP BY clause and i don't...
|
by: D. Dante Lorenso |
last post by:
I need to know that original number of rows that WOULD have been returned
by a SELECT statement if the LIMIT / OFFSET where not present in the
statement.
Is there a way to get this data from PG ?...
|
by: Terry E Dow |
last post by:
Howdy,
I am having trouble with the objectCategory=group member.Count attribute.
I get one of three counts, a number between 1-999, no member (does not
contain member property), or 0. Using...
|
by: Thelma Lubkin |
last post by:
My form/subform combination that allows user to display 'ColorSet'
records, move to other records via a selector, to add,delete, and
edit them, and to manage the related 'Color' records from the...
|
by: Kriston-Vizi Janos |
last post by:
Dear Mr. Kern, and Members,
Thank you very much for the fast answer, my question became
over-simplified.
My source code is appended below. It uses two text files (L.txt and
GC.txt) as input...
|
by: Barb |
last post by:
How can I limit the number of items that show up in a dropdown list at one
time? I have a list of states, and because my dropdown list is near the
bottom of the page, it becomes a drop-up list. ...
|
by: suchismita.83 |
last post by:
Hi,
I am developing a messaging form which will use webmail in c#.The
mailing list will inherit costomised groups from MOSS 2007 site.So the
mailing list may vary in future.
I just wanted to...
|
by: Craig B. |
last post by:
Does any know if there is a limitation on the number of items you can
contain within an SQL list. (e.g. WHERE id IN (,,,,) ). And if that
differs from having a sub-query oppose to literal values?...
|
by: dlite922 |
last post by:
hey guys,
I'm doing some brain storming and getting ideas to come up with a solution.
I have a list of ....data... that is displayed 10 per page with the LIMIT clause.
Simply put: My...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| | |