| COUNTING THE DISTINCT OCCURENCE OF DATA FROM MULTIPLE COLUMNS [message #576431] |
Mon, 04 February 2013 22:51  |
 |
nischalinn
Messages: 80 Registered: May 2012 Location: nepal
|
Member |
|
|
CREATE TABLE FEB05
(NAME VARCHAR2(20),
CITY VARCHAR2(20))
INSERT INTO FEB05 VALUES ('AKON','CIT22')
INSERT INTO FEB05 VALUES ('MARIA','WOT101');
INSERT INTO FEB05 VALUES ('GEORGE','NYK580');
INSERT INTO FEB05 VALUES ('JULIA','NYK580');
INSERT INTO FEB05 VALUES ('MAVEN','CIT22');
INSERT INTO FEB05 VALUES ('MARIA','LA370');
INSERT INTO FEB05 VALUES ('JULIA','CIT22') ;
INSERT INTO FEB05 VALUES ('JULIA','BOSTON055') ;
INSERT INTO FEB05 VALUES ('KATY','CIT22');
I WANT A QUERY THAT WILL GIVE O/P AS TO GET DISTINCT COUNT OF NAME AND CITY COLUMN seperately.
I.E. THE O/P SHOULD BE
Quote:Count(dist name) Count(dist city)
6 5
|
|
|
|
|
|
|
|
|
|
|
|
|
|