Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Sql query
Hello Friends I am struck up with typical problem. I got this problem while querying data from Oracle Tables. I can't explain the problem as it is with my project business jargons so I am formulated the problem in following way. Let us assume that table and data of it as given below: TABLE : PLAYER
PLAYER NAME TEAM SCORE Tendulkar IND 83 Tendulkar IND 42 Tendulkar IND 138 Tendulkar IND 67 Tendulkar BOMBAY 159 Dravid IND 32 Dravid IND 53 Dravid SZONE 72 Yuvaraj NZONE 91 Yuvaraj IND 27 Yuvaraj IND 42 Yuvaraj IND 12 Lara WI 83
PLAYER TEAM SCORE1 SCORE2 SCORE3 Tendulkar IND 138 83 67 Dravid IND 53 32 Yuvaraj IND 42 27 12 Sewag IND 47
CREATE TABLE PLAYER (PNAME VARCHAR2(20),TEAM VARCHAR2(10), SCORE NUMBER(5)); INSERT INTO PLAYER VALUES ('Tendulkar','IND',138); INSERT INTO PLAYER VALUES ('Tendulkar','IND',83); INSERT INTO PLAYER VALUES ('Tendulkar','IND',42); INSERT INTO PLAYER VALUES ('Tendulkar','IND',67); INSERT INTO PLAYER VALUES ('Tendulkar','BOMBAY',159); INSERT INTO PLAYER VALUES ('Dravid','IND',53); INSERT INTO PLAYER VALUES ('Dravid','IND',32); INSERT INTO PLAYER VALUES ('Dravid','SZONE',72); INSERT INTO PLAYER VALUES ('Yuvaraj','NZONE',91); INSERT INTO PLAYER VALUES ('Yuvaraj','IND',27); INSERT INTO PLAYER VALUES ('Yuvaraj','IND',12); INSERT INTO PLAYER VALUES ('Yuvaraj','IND',42); INSERT INTO PLAYER VALUES ('Lara','WI',83);INSERT INTO PLAYER VALUES ('Sewag','IND',47); INSERT INTO PLAYER VALUES ('Sewag','NZONE',17); Received on Sun Sep 09 2001 - 20:31:36 CDT