OraFAQ Forum: Server Administration » Select only one record from query result?

Home » RDBMS Server » Server Administration » Select only one record from query result?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Select only one record from query result? [message #370893]

Thu, 02 March 2000 01:05

kat
Messages: 15
Registered: February 2000

Junior Member

Hi,
let me give an example, let's say I have this select statement:
"Select CustomerName from tblCustomer where LastName ='White'"
It's very possible that the result of this query will give me more than one record. But I can only display one of them. And it doesnt matter which record is displayed as long as I am showing one of the many records that meet the criteria. Can someone tell me how it can be done? Thank you.

Report message to a moderator

Re: Select only one record from query result? [message #370914 is a reply to message #370893]

Mon, 06 March 2000 09:42

Andreas Pollmeier
Messages: 7
Registered: February 2000

Junior Member

Hi!
Try this:
"Select min(CustomerName) from tblCustomer where LastName ='White'"

Andreas

Report message to a moderator

Previous Topic:	Which is faster Join or subquery
Next Topic:	Re: NOT IN operator - very slow

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Feb 08 05:40:18 CST 2023