SQL Language (MOSC)

MOSC Banner

Multi or Single Record using SQL

edited Jul 14, 2017 5:00AM in SQL Language (MOSC) 1 commentAnswered ✓

Hello All Master,

I have a question how to display multi or single record note using SQL effectively?

CREATE TABLE ZZZZ

  (DOCNBR VARCHAR(255), ZN VARCHAR(255)

  );

 

INSERT INTO ZZZZ VALUES ('138200806', 'A');

INSERT INTO ZZZZ VALUES ('138200807', 'C');

INSERT INTO ZZZZ VALUES ('138200807', 'C');

INSERT INTO ZZZZ VALUES ('138200808', 'B');

INSERT INTO ZZZZ VALUES ('138200808', 'B');

INSERT INTO ZZZZ VALUES ('138200808', 'D');

INSERT INTO ZZZZ VALUES ('138200808', 'C');

if DOCNBR having multiple ZN then return SINGLE else MULTI group by DOCNBR.

Like 138200807, even it has more than 1 record, query should return single because it only have 1 ZN

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center