Re: SQL Puzzle: Select a close number.

This seems to work but someone else will have to decide if its 'eloquent'.

select street_number, street_name
from address
where
  street_number - 1234 =
  (select min(abs(street_number - 1234)) from address)

Have a good weekend.
-Daniel Nonen

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Steve Shiflett wrote:
>Here's the deal:
 

>create table address(
>street_number varchar2(6),
>street_name varchar2(40)
>);

>insert into this table values:
 

>1005 Main St
>1022 Main St
>1105 Main St
>1300 Main St
>1555 Main St
>1703 Main St
 

>Question:
 

>What is the SQL statement that will return
>the closest street number to street number = '1234'?
 

>You should get 1300.
 

>I can think of some very ugly ways to do this,
>but there *must* be some eloquent way. Does this
>look fun to you? If so, please give me a clue.
 

>Steve Shiflett
Received on Fri Jun 07 1996 - 00:00:00 CEST