Hi, I'm not sure why I get doubles in my result set when I make DISTINCT in the SQL statement?
---------
select DISTINCT Sale from SoftwareFinal where Sale<>-1
---------
when I display the ...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/Q_20015214.htm...
Zones:
ASPDate Answered: 01/01/2001 Rating: 6.2 Views: 0
I have a table that i am doing distinct on the employee name, but I want to return all the other columns, how can i do this in the select statement?
select distinct(empno) from employee.
sele...
http://www.experts-exchange.com/Database/Oracle/Q_20286742.html
Zones:
OracleDate Answered: 06/11/2002 Rating: 7.4 Views: 0
This works:
1. SELECT DLookUp("sex","p_a_sex","[ID] = " & "" & [RESPONDENTS.SEX] & "") AS Gender FROM Respondents;
This doesn't:
2. SELECT DISTINCT DLookUp("sex","p_a_sex","[ID] = " & "" & ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20713953.html
Zones:
MS AccessDate Answered: 11/24/2003 Rating: 9.0 Views: 4
here's my problem:
i have a table which lists players scores and it has the following format
id,userid,nickname,score,... etc
each score entry is added to the last score and inserted into ...
http://www.experts-exchange.com/Database/MySQL/Q_20780853.html
Zones:
MySQL ServerDate Answered: 10/29/2003 Rating: 7.8 Views: 0
hI! I'm having a bit of a problem using the SHAPE command. I have tables
Vendors Product ProductType Quantity
------- ------- ------- ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20956475.html
Zones:
MS AccessDate Answered: 06/14/2004 Rating: 6.6 Views: 0
I have one xml file which looks like...
<DataItems>
<Count>8</Count>
<DataItem>
<dvalue>Beverages</dvalue>
<dvalue>Aniseed Syrup</dvalue>
...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/XML/Q_20987696.htm...
Zones:
XMLDate Answered: 05/13/2004 Rating: 5.6 Views: 0
I want to select several fields from a table using distinct
but I only want the first three to use the distinct. Is there a way to do this or would I have to use sub query?
http://www.experts-exchange.com/Database/Oracle/Q_21012479.html
Zones:
OracleDate Answered: 09/23/2004 Rating: 8.0 Views: 0
select distinct p.vol_id,
p.title,
p.first_name,
p.last_name
From
vmis.person p,
(select vol_id, activi...
http://www.experts-exchange.com/Database/Oracle/Q_21026515.html
Zones:
OracleDate Answered: 06/16/2004 Rating: 9.4 Views: 0
i have two sql and i am trying to get them as one and display the results
the 1st returns a name
select distinct name
from data
and num=1234;
this will return
name
---------
henri...
http://www.experts-exchange.com/Database/Oracle/Q_21028936.html
Zones:
OracleDate Answered: 06/21/2004 Rating: 7.4 Views: 0
I am trying to insert records into a table where studentid is the primary key. Therefore, I need to retreive records where the studentid is unique. The query I have posted is not working:
SELE...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21047026.html
Zones:
MS SQL ServerDate Answered: 07/03/2004 Rating: 8.4 Views: 0
