Re: error al realizar un subquery
en tu query, la subquery tiene que solo retornar una columna que va a contener los valores que se van a comparar con la columna cantid_acm
Aqui decis que estas buscando la cantidad de acm, los acm es el count de cada row?
porque creo que solo esta query te va a dar ese resultado
SELECT count (*) as repetidos, corre,cantid_odc,noodc,rdc
FROM baseacm
GROUP BY corre,cantid_odc,noodc,rdc
HAVING repetidos >1
Diego Medina
Web Developer
http://www.fmpwizard.com
P.S. Please read
this post if you are going to post code
Subject
Views
Written By
Posted
4532
February 20, 2008 03:15PM
Re: error al realizar un subquery
1954
February 20, 2008 06:31PM
1700
February 21, 2008 08:45AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.