SQL: Select closest number

Sep 10, 2017 9:39PM

Hello Guru,

I have below data

CREATE TABLE TT1

(DOCNBR NUMBER, PRIORITY NUMBER, NBR NUMBER

);

insert into TT1 (DOCNBR,PRIORITY,NBR) values (1,445,165);

insert into TT1 (DOCNBR,PRIORITY,NBR) values (2,445,90);

insert into TT1 (DOCNBR,PRIORITY,NBR) values (2,445,450);

insert into TT1 (DOCNBR,PRIORITY,NBR) values (3,445,481);

insert into TT1 (DOCNBR,PRIORITY,NBR) values (4,445,483);

insert into TT1 (DOCNBR,PRIORITY,NBR) values (5,443,189);

insert into TT1 (DOCNBR,PRIORITY,NBR) values (5,443,481);

insert into TT1 (DOCNBR,PRIORITY,NBR) values (5,443,483);

insert into TT1 (DOCNBR,PRIORITY,NBR) values (6,443,172);

insert into TT1 (DOCNBR,PRIORITY,NBR) values (6,443,475);

I would like to get closest NBR with the highest PRIORITY based on entered value on the same DOCNBR

SQL*Plus (MOSC)