Database

Select A,B,C.... From Table1 ORDER BY H DESC

Select F,G,ORDER BY H DESC SUM(D), A,B,C From Table1 Group by A,B,C

select substring('MSantos@yahoo.com', 1, charindex('@', 'MSantos@yahoo.com') - 1)

SELECT COUNT(*), SUM(price)
FROM Orders o1
WHERE cust_id=3
AND 50 <= (select count(*) 
           from Orders o2
           where o2.cust_id = o1.cust_id
           and o2.date < o1.date)

Tony_P wrote:

Is subquerying the only solution

SELECT COUNT(*), SUM(price)
FROM (SELECT TOP 50 Price
      FROM   Orders
      WHERE cust_id=3
      ORDER BY date DESC) tableAlias

hatan86 wrote:

OleDbDataAdapter ad;

hatan86 wrote:

OleDbException was unhandled
Syntax error in INSERT INTO statement
I've checked it and I can't find any syntax errors in it

Jon_Boy wrote:

I'm getting sucked into a vortex of stupid questions

gnjunge wrote:

I started with some join, but saw it didn't give the right results.
This query should be able to run under heavy stress.

...
from tablename alias1
     inner join
     tablename alias2
     on alias1.carid = alias2.carid
where alias1.partid = 5
and   alias2.partid = 7