S
subs
i have a table like
carrier service equipment price comment
hubs imdl 48 200 current
hubs imdl 48 500
hubs OTR 48 2899
now i need a query which can extract unique rows(for uniqueness, the
fields considered should be carrier,service,equipment). Als Whenever
the comment field has a value, then that row has to be selected.
So in the above example, the first row and the third rows are
selected. Second row is not selected because the first row which is
same in carrier, service and equipment has a value under comment
column.
Can somebody pls help me with a query
carrier service equipment price comment
hubs imdl 48 200 current
hubs imdl 48 500
hubs OTR 48 2899
now i need a query which can extract unique rows(for uniqueness, the
fields considered should be carrier,service,equipment). Als Whenever
the comment field has a value, then that row has to be selected.
So in the above example, the first row and the third rows are
selected. Second row is not selected because the first row which is
same in carrier, service and equipment has a value under comment
column.
Can somebody pls help me with a query