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

write a query to follwoing table amount year quarter 254556 2003 first 546332 2003 second 129034 2003 third 490223 2003 fourth 165768 2004 first 265443 2004 second 510412 2004 third 435690 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 254556 546332 129034 490223 2004 165768 265443 510412 435690

2 Answers   TCS,

suppose i have source 101 a 101 b 101 c 101 d i want target like 101 abcd how will u achive this please give me the answer

5 Answers   ITC Infotech, TCS,

If i have one source having 10 ports.In a mapping i use that source one target having that ten ports.Data from 5 ports are going to target through a mapplet and another 5 ports are going to target through another mapplet.Both 2 mapplets are intially passive in nature.But presently my requirment to convert on mapplet to ACtive.How can i do it.

3 Answers   TCS,

wt is the difference between truncate and delete in which situation u use delete and truncate in real time..

4 Answers   TCS,

what is session parameters?

1 Answers   Cap Gemini,

How to generate or load values in to the target table based on a column value using informatica etl tool.

0 Answers   Informatica,

Why do you use Mapping Parameter and mapping variable?

0 Answers  

How to load a Dimension ? and how to load a fact table?

0 Answers  

split two strings into two columns For Eg. Source:-Full Name: Shiva Kumar Target:- First Name:Shiva Last Name:Kumar

1 Answers   Cap Gemini, TCS, Wipro,

why cant we put a sequence generator or upd strategy transformation before joiner transformation?

2 Answers   Satyam,

I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?

5 Answers   Span Systems,

What are the types of schemas we have in data warehouse.

0 Answers