Retrieve only top record using IN 1

[Zoom1234]

Hi,
I have 'Order' table which has many account nos for a particluar tel no.
So if i query

select * from orders where telno = '1234' order by inid;

i can get one or more than one records.
Now i have a set of telnos for which i want to retreive records for each telno with inid as max.

select * from orders where telno in ('1234','5678',...)

How do i do it.

TIA

 

[TonyGroves]

Do you mean you want to get for each telno value the orders record with the highest value of inid? If so, you could use:
[tt]
SELECT orders.*
FROM
(
SELECT telno,MAX(inid) m
FROM orders
WHERE telno IN ('1234','5678')
GROUP BY telno
)
sq
JOIN orders o ON sq.telno=o.telno AND sq.m=o.inid
[/tt]

 

[Zoom1234]

Thanks TonyGroves,
Query works perfectly except i am getting 19 records instead of 20. May be the data is not consistent. I will check it out.