Hi,

I have a table catmst.I am giving the sample data:

catno artist title stk price
1234 bryan adams 18 till i die 10 9.99
4578 bryan adams 18 till i die 5 10.99
53467 bryan adams 18 till i die 0 6.99

I want to fetch the records depending on title i.e.
if there r 2 or more entries for same title, i want to fetch the
records for which stk>0.If there r 2 or more such entries for stk>0
then i would like to fetch the title which is having lowest price.
If none of the title r in stock(stk=0) then i want to fetch the
record for highest price.

Pls build the query for me.

Thanx.