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