SQL Puzzle: Select a close number.
From: Steve Shiflett <shiflett_steve_at_mm.ssd.lmsc.lockheed.com>
Date: 1996/06/03
Message-ID: <31B35ADB.43F6_at_mm.ssd.lmsc.lockheed.com>#1/1
Date: 1996/06/03
Message-ID: <31B35ADB.43F6_at_mm.ssd.lmsc.lockheed.com>#1/1
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
shiflett_steve_at_mm.ssd.lmsc.lockheed.com
Received on Mon Jun 03 1996 - 00:00:00 CEST