Help i am stuck !!
Display SalesOrderID, OrderQty and UnitPrice from the SalesOrderDetail table where a similar unit price needs to be marked with an identical value.
i have no idea what this question means... help me.
2007-02-16 04:39:11 · 3 answers · asked by Alpha-Male 1 in Computers & Internet ➔ Programming & Design
similar unit price needs to be marked as identical...
2007-02-16 04:46:58 · update #1
SELECT SalesOrderID, OrderQty, UnitPrice
FROM SalesOrderDetail
WHERE UnitPrice = SOME VALUE
2007-02-16 04:44:53 · answer #1 · answered by Anonymous · 3⤊ 0⤋
select SalesOrderDetail.*,x.UnitPrice mark from SalesOrderDetail SOD
LEFT JOIN
(select UnitPrice from SalesOrderDetail group by UnitPrice having count(*)>1) x
on SOD.UnitPrice=x.UnitPrice
2007-02-17 07:47:43 · answer #2 · answered by Serge M 6 · 0⤊ 0⤋
What this means is you need to put down the game controller and open the textbook.
It's a very basic, simple SQL statement, yet even when dhvrm gives you the exact answer, you don't understand it.
2007-02-16 15:05:27 · answer #3 · answered by rod 6 · 1⤊ 0⤋