Hi Guys,
I have to be show results as below.I'm using Oracle 10G. I have to be assign unique value for each group.Here I have given sample table and data.
create table FLIGHT_OFFERS
(
ID NUMBER(10),
TRIP_TYPE VARCHAR2(10),
AIRLINE VARCHAR2(50),
REGION VARCHAR2(100),
STATUS VARCHAR2(10),
DEPARTURE_CODE VARCHAR2(10)
)
/
insert into FLIGHT_OFFERS (ID, TRIP_TYPE, AIRLINE, REGION, STATUS, DEPARTURE_CODE)
values (229, '2', 'Batavia Air(Y6)', 'ISLAND', 'Active', 'DEL');
insert into FLIGHT_OFFERS (ID, TRIP_TYPE, AIRLINE, REGION, STATUS, DEPARTURE_CODE)
values (234, '2', 'Jet Airways(9W)', 'madhan', 'Active', 'LON');
insert into FLIGHT_OFFERS (ID, TRIP_TYPE, AIRLINE, REGION, STATUS, DEPARTURE_CODE)
values (256, '1', 'Baker Aviation(8Q)', 'thaai', 'Active', 'DUB');
insert into FLIGHT_OFFERS (ID, TRIP_TYPE, AIRLINE, REGION, STATUS, DEPARTURE_CODE)
values (258, '2', 'Thomas Cook Airlines(MT)', 'thaai', 'Active', 'MJC');
insert into FLIGHT_OFFERS (ID, TRIP_TYPE, AIRLINE, REGION, STATUS, DEPARTURE_CODE)
values (268, '1', 'Air India(AI)', 'ISLAND', 'Active', 'LHR');
insert into FLIGHT_OFFERS (ID, TRIP_TYPE, AIRLINE, REGION, STATUS, DEPARTURE_CODE)
values (270, '2', 'Air India(AI)', 'ISLAND', 'Active', 'LHR');
insert into FLIGHT_OFFERS (ID, TRIP_TYPE, AIRLINE, REGION, STATUS, DEPARTURE_CODE)
values (273, '2', 'Baker Aviation(8Q)', 'thaai', 'Active', 'DUB');
insert into FLIGHT_OFFERS (ID, TRIP_TYPE, AIRLINE, REGION, STATUS, DEPARTURE_CODE)
values (276, '1', 'British Airways(BA)', 'Middle East', 'Active', 'DUB');
insert into FLIGHT_OFFERS (ID, TRIP_TYPE, AIRLINE, REGION, STATUS, DEPARTURE_CODE)
values (277, '1', 'Jet Airways(9W)', 'Middle East', 'Active', 'LHR');
insert into FLIGHT_OFFERS (ID, TRIP_TYPE, AIRLINE, REGION, STATUS, DEPARTURE_CODE)
values (278, '1', 'Etihad Airways(EY)', 'Middle East', 'Active', 'MJC');
insert into FLIGHT_OFFERS (ID, TRIP_TYPE, AIRLINE, REGION, STATUS, DEPARTURE_CODE)
values (279, '1', 'jet(UL)', 'Middle East', 'Active', 'LHR');
insert into FLIGHT_OFFERS (ID, TRIP_TYPE, AIRLINE, REGION, STATUS, DEPARTURE_CODE)
values (281, '1', 'Air India(AI)', 'Indian Ocean', 'Active', 'LHR');
insert into FLIGHT_OFFERS (ID, TRIP_TYPE, AIRLINE, REGION, STATUS, DEPARTURE_CODE)
values (282, '2', 'jet(UL)', 'Africa', 'Active', 'LHR');
insert into FLIGHT_OFFERS (ID, TRIP_TYPE, AIRLINE, REGION, STATUS, DEPARTURE_CODE)
values (283, '2', 'Batavia Air(Y6)', 'Africa', 'Active', 'LON');
insert into FLIGHT_OFFERS (ID, TRIP_TYPE, AIRLINE, REGION, STATUS, DEPARTURE_CODE)
values (284, '2', 'Qatar Airways(QR)', 'Africa', 'Active', 'LON');
insert into FLIGHT_OFFERS (ID, TRIP_TYPE, AIRLINE, REGION, STATUS, DEPARTURE_CODE)
values (285, '2', 'Jet Airways(9W)', 'Africa', 'Active', 'LON');
insert into FLIGHT_OFFERS (ID, TRIP_TYPE, AIRLINE, REGION, STATUS, DEPARTURE_CODE)
values (286, '2', 'QANTAS AIRWAYS(QF)', 'Africa', 'Active', 'LHR');
insert into FLIGHT_OFFERS (ID, TRIP_TYPE, AIRLINE, REGION, STATUS, DEPARTURE_CODE)
values (287, '2', 'Thomas Cook Airlines(MT)', 'Canada & the USA', 'Active', 'LGW');
commit;
Thanks,
Jai