만약 이정도라면

select min (a_id), a_title
from A
group by a_title

해도 답이 될 것 같습니다.

우선 답변 감사합니다... 만,

님이 댓글 다신 쿼리는

b_id 가 다르고 a_title 이 같은 데이터가 있을 경우 제대로 결과값이 나오질 않을 것 같네요...

table A
a_id b_id a_title
('000000000000000001', '000000000001', 'title1')
('000000000000000002', '000000000001', 'title1')
('000000000000000003', '000000000002', 'title2')
('000000000000000004', '000000000002', 'title2')
('000000000000000005', '000000000003', 'title3')
('000000000000000006', '000000000004', 'title4')
('000000000000000007', '000000000004', 'title5')

('000000000000000008', '000000000004', 'title1')

이럴 경우에 말이죠...

제가 원하는 결과값은,

a_id a_title
('000000000000000001', 'title1')
('000000000000000003', 'title2')
('000000000000000005', 'title3')
('000000000000000006', 'title4')
('000000000000000007', 'title5')

('000000000000000008', 'title1')

이렇게 나오는 거거든요... 제발 누가 쿼리 좀 만들어 주세요...

아래를 돌려보세요......

create table table_A(
a_id char(18),
b_id  char(12),
a_title char(10)
);
insert into table_A values ('000000000000000001', '000000000001', 'title1');
insert into table_A values ('000000000000000002', '000000000001', 'title1');
insert into table_A values ('000000000000000003', '000000000002', 'title2');
insert into table_A values ('000000000000000004', '000000000002', 'title2');
insert into table_A values ('000000000000000005', '000000000003', 'title3');
insert into table_A values ('000000000000000006', '000000000004', 'title4');
insert into table_A values ('000000000000000007', '000000000004', 'title5');
insert into table_A values ('000000000000000008', '000000000004', 'title1');
commit;

select b_id,a_title,
       min(a_id) a_id
  into #tmp1
  from table_A
group by b_id, a_title
;

select b_id,
    a_id,
    a_title,
       min(rowid(table_A)) rd
  into #tmp2
  from table_A
group by b_id, a_id,a_title
;

select a.a_id,
 a.a_title
  from table_A a,
       #tmp1 b,
       #tmp2 c
 where a.b_id = b.b_id
   and a.a_title = b.a_title
   and a.a_title = c.a_title
   and a.b_id = c.b_id
   and b.a_id = c.a_id
   and c.rd = rowid(a)
order by a.a_id
;

 
a_id a_title
('000000000000000001', 'title1')
('000000000000000003', 'title2')
('000000000000000005', 'title3')
('000000000000000006', 'title4')
('000000000000000007', 'title5')

('000000000000000008', 'title1')

보니까.. 뭘하실려는 지는 알겠습니다.

담부터.. 질문하실때는 사용 DB를 꼭 써주세요.. 위는 ASIQ기준으로 했습니다.

12.43버젼에서는 현재 한 쿼리로는 안됩니다.

본인의 쿼리와 답변다신 분의 쿼리를 종합합니다...ㅋㅋ

select a.a_id, a.a_title from A a, B b where a.b_id = b.b_id and b.b_flag = 0
union
select min (a_id), a_title
from A
group by a_title

a_id               a_title
----               -------
000000000000000001 title1 
000000000000000003 title2 
000000000000000005 title3 
000000000000000006 title4 
000000000000000007 title5 
000000000000000008 title1 

수고하세요