select count(1) from emp? what is the o/p?

Answer Posted / chandu

count(1) means it will count based on 1st column in the
select statement

Is This Answer Correct ?    14 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

lookup transformation with screenshots

3643


what is the complex transformation you used in informatica

2288


Write the unconnected lookup syntax and how to return more than one column.

699


what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

1879


In development project what is the process to follow for an etl developer from day1

1372






How to use pmcmd utility command?

684


What are the validations that you can perform in oracle and in informatica ? Advance Thanks

1737


Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

3605


What do you mean by worklet?

721


How many ways are there to do 'remove duplicate records in informatica'?

672


difference between repository database and repository service?

709


Tell me about Propagate functions in informatica

621


What is the sequence generator transformation in informatica?

737


how to load rows into fact table in data warehouse

746


What is primary and backup node?

803