[JavaWannaBe]

I am trying to list the three most expensive products in the Products table. (Must use NOT EXIST STATEMENT)

Here is my Products table

PID PNAME CITY QUANTITY PRICE
--- ------------- -------------------- ---------- ----------
p01 comb Dallas 111400 .5
p02 brush Newark 203000 .5
p03 razor Duluth 150600 1
p04 pen Duluth 125300 1
p05 pencil Dallas 221400 1
p06 folder Dallas 123100 2
p07 case Newark 100500 1

7 rows selected.

Any useful links to NOT EXISTS STATEMENTS would also be helpful.

Thank You

[Amadeus]

There is no actual NOT EXISTS statement, only the negation of the EXISTS statement with the NOT operator...here is a good look at the usage of both:
http://www.techonthe.../sql/exists.php

[born2c0de]

or you can use PL/SQL to display the expensive products one by one in a loop.