Answer / rama

select (distinct max(sal)) from emp

Answer / sudheer113

MAX(SAL) will not give duplicate records in a single group

Answer / anil kumar

select distinct max(sal) from table name

Answer / deva

select (distinct max(sal)) from emp
group by sal.

When ever you use goupfunctions in select statement grup by clause is must.....other wise it will throw an error

Answer / asdfg

select (distinct max(sal)) from emp
group by sal.

When ever you use goupfunctions in select statement grup by
clause is must.....other wise it will throw an error

Can you start a batches with in a batch?

1 Answers  

hi talents, how do u get sequece numbers with oracle sequence generator function in informatica.... i dont need to use sequence generator transformation..... how do u achieve this???

3 Answers   HP,

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix.

1 Answers   DELL,

if the session fails after 100 records agian we have to starts the session or we go for recovery session

2 Answers   TCS,

What is the role of informatica in project ?Like i showed financial projects?

1 Answers   Amdocs,

What is deployemnt groups, Lables, query and dynamic deployment group.

1 Answers   IBM, SVP,

What is standalone command task?

0 Answers  

What is a snowflake schema?

0 Answers  

what is index?how it can work in informatica

0 Answers  

I have a scenario which load the data frm single source to 2 targets as T1, T2, and T1 have a P.K and T2 have F.K relations. first data has to load in T2, and then data load to T1 if that record exist in T1... how can we acheive it?

2 Answers   Ness Technologies,

what is the dashbords?

1 Answers   IBM,

what is the difference between Informatica 7.1 and Abinitio?

1 Answers   TCS,