Sql Help Please

[massmaharaj]

oka status table undi

andulo oka 5 etl process names unnayi avi anni oka source system ki relation undi

ippudu

5 etl process names suppose

process1, process2, process3 , process4 , process5 unnayi

ippudu sum chesthe 5 raavali ela raaaaaaayali sql

[massmaharaj]

help

[lolliman]

help

[lolliman]

baa edo sql server ane thaadu vundi andulo veyyu okasari

[massmaharaj]

ekkada veyali emi thread adhi do you have any link

[lolliman]

koncham Q sariga adugu baaa? edo sql server ane thaadu vundi choodu pinane

[iTeachSAP]

process names columns lo unnaya , leka rows lo unnaya?

[massmaharaj]

they are rows
process1
process2
process3
process4
process5

all sum chesthe 5 ravaili

[charygaru]

select sum(process) from table name

[lolliman]

[quote name='massmaharaj' timestamp='1351011817' post='1302676694']
they are rows
process1
process2
process3
process4
process5

all sum chesthe 5 ravaili
[/quote]

antee naaku ardam kaale kaani... [b]count(row_name)[/b] raaste saripothadi kadaaa

[vikuba]

select count ( process_name) from table

[vikuba]

[quote name='charygaru' timestamp='1351011933' post='1302676707']
select sum(process) from table name
[/quote]
count ji

[Ka NTR i]

[quote name='massmaharaj' timestamp='1351010222' post='1302676535']
oka status table undi

andulo oka 5 etl process names unnayi avi anni oka [size=5][b]source system ki relation undi[/b][/size]

ippudu

5 etl process names suppose

process1, process2, process3 , process4 , process5 unnayi

ippudu sum chesthe 5 raavali ela raaaaaaayali sql
[/quote]


Source system ki ... ee ID relation enti?
select count(distinct PROCESS_COLUMN) Total_Processes from TABLE_NAME;


Tested query in Oracle

with t
as
( select 'process1' as col1, 12 as ID from dual
union
select 'process2' as col1, 12 as ID from dual
union
select 'process3' as col1, 12 as ID from dual
union
select 'process4' as col1, 12 as ID from dual
union
select 'process5' as col1, 12 as ID from dual)
select count(distinct col1) Total_Processes from t;

[lolliman]

[quote name='Aamphat' timestamp='1351012497' post='1302676781']
select count ( process_name) from table
[/quote]
[quote name='Aamphat' timestamp='1351012522' post='1302676786']
count ji
[/quote]




[quote name='BlueBerry' timestamp='1351012581' post='1302676792']


Source system ki ... ee ID relation enti?
select count(distinct PROCESS_COLUMN) Total_Processes from TABLE_NAME;


Tested query in Oracle

with t
as
( select 'process1' as col1, 12 as ID from dual
union
select 'process2' as col1, 12 as ID from dual
union
select 'process3' as col1, 12 as ID from dual
union
select 'process4' as col1, 12 as ID from dual
union
select 'process5' as col1, 12 as ID from dual)
select count(distinct col1) Total_Processes from t;
[/quote]

distinct avasaram ledanukuntaaaa

[vikuba]

thread esinodu edi ?