CareerCup

It actually depends on the indexes.

if you have B+tree index on date, then AND is correct answer.

If you have B+tree index on custid, then using intersect is better.

select CustID from TABLE where Date=1 or Date=10

I have no idea about the most optimal one, any suggestion?

isn't davidf answer correct??

I feel the one with the IN clause in the most optimal one , because the one with the subquery and the intersect clauses will take more time is a costlier SQL statement to execute.

select * from TABLE where
TO_DATE(insertion_date,'DD-MON-YY') IN
(TO_DATE('02-MAR-10','DD-MON-YY'),TO_DATE('04-MAR-10','DD-MON-YY'))
>/

but is the date above actually specified?? no right. so how can we give the date like this?
we may have to use GroupBy to group using the customer id and to count number of occurences to check if the entries are equal to 2 or more
right? am not so good with sql queries..but is this logic correct?

Select Cust_ID,Date
   from (select distinct cust_id, date 
From table)

Select A.Cust_ID,A.Date
   from (select distinct cust_id, date 
   From table) A
   Group By (A.Cust_id,A.date)
   having count('*')=2

select CustId, count(distinct Date) as num from TABLENAME group by CustID having num=2

Select * from Test where Cust_id IN
(
Select Cust_Id
from test
group by Cust_id
Having COUNT(date)=2
)

Wouldn't this work??

SELECT CUSTOMERID FROM TABLE GROUP BY CUSTOMERID HAVING COUNT(SALEDATE) =2

select custid
from orders ord_out
exists( select 1
from orders ord_in
where ord_in.custid=ord_out.custid
and ord_out.ord_Date <> ord_in.ord_date);

SELECT Cust_ID FROM Orders WHERE Order_Date = 1
INTERSECT
SELECT Cust_ID FROM Orders WHERE Order_Date = 2;

select cust_id
from order_t t
where order_dttm=date1
and exists(select 1 from
order_t t1 where t1.cust_id=t.cust_id
t1.order_dttm=date2)

select 
custid 
from (
select date, custid from table
group by date,custid)
group by custid having count(date)>1;

Select * FROM Table WHERE Date IN[date1, date2];

select count(distinct Date) as num from TABLENAME group by CustID where num=2