Hi Lists,
I have a table CONTRACTOR_RATES like this -
Primay key is - (CONTRACTOR_NUMBER,SYNTHETIC_CODE,ISSUE_NUMBER)
Name Null? Type
------------------------------- -------- ----
CONTRACTOR_NUMBER NOT NULL VARCHAR2(8)
SYNTHETIC_CODE NOT NULL VARCHAR2(4)
ISSUE_NUMBER NOT NULL NUMBER(6)
BT_RATE NUMBER(7,2)
BASIC_RATE NUMBER(7,2)
STORES_RATE NUMBER(7,2)
The objective is Given a particular contractor_number
List the maximum issue_number and relevant details(bt_rate,....)
synthetic_code wise. Can anybody pl. give the query.
Contractor_number synthetic_code Issue_number
11 1 5
12 1 10
11 2 3
11 3 1
11 1 6
11 2 8
Output if we input Contractor_number = 11 should be -
11 1 6 with other three fields
values
11 2 8 with other three fields
values
11 3 1 with other three fields
values
Received on Fri Jun 16 2000 - 08:57:07 CDT
