Ask a Question related to Dreamweaver AppDev, Design and Development.
-
The Ox #1
Using SELECT DISTINCT
Thanks for the earlier help, I have got the SELECT DISTINCT to work but I
would like to also bring in the ID (Primary Key) field as well. I have had a
quick look around but can't seem to find an answer.
Any help with tutorial or examples would be appreciated.
Many thanks in advance
Rob
VB Script / ASP / Access 2000
The Ox Guest
-
Select Distinct Statement Help
I have a question about the following PHP script - I got it off a web site tutorial on how to count users logged into your site - my question is... -
SELECT DISTINCT from two tables
Hi I have two table which are related: table1 holds personellinformation table2 holds nodeInformation The nodes in table2 can have a... -
Select Distinct
I feel a little stupid sending this, but I must be having a mental block or something. I am trying to do a Select Distinct on a column from a... -
SELECT DISTINCT + ORDER BY gives ERROR 145: ORDER BY items must appear in the select list if SELECT DISTINCT is specified.
Following is my stored procedure. If I take the DISTINCT out then everything works fine. BUT I need the distinct because it returns duplicate... -
SELECT DISTINCT + ORDER BY gives ERROR 145: ORDER BY items mustappear in the select list if SELECT DISTINCT is specified.
Dan, You should be able to do this: SELECT Id, FaxID, ReceivedTime, Pages FROM ( SELECT DISTINCT .Id AS Id, -
Julian Roberts #2 Re: Using SELECT DISTINCT
If you think about it, it's not logical. If you have several records that
are the same but with different ID's, then the SQL won't know which ID to
use for output. I've an article that covers some of this
[url]http://www.charon.co.uk/content.aspx?CategoryID=27&ArticleID=50[/url]
--
Jules
[url]http://www.charon.co.uk/charoncart[/url]
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004
Julian Roberts Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
