query help please

[whtisthat]

I have 8 org_id and more then 10000 order_number I need to find the distinct org_id and just 1 order_number in all org_id to test there currency may be org_id,order_number,currency from oe_order_headers_all

Thanks

 

[nagornyi]

select
org_id
, order_number
, currency
from
oe_order_headers_all
where rownum =1

 

[whtisthat]

sir
with that query I am only getting one org_id if i want muntiple org_id and order_num how can I do that

Thanks

 

[nagornyi]

select distinct
org_id
, (select order_number from oe_order_headers_all where org_id = a.org_id and rownum=1) order_number
from
oe_order_headers_all a

 

[whtisthat]

Thanks that was perfect Thanks!