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

Answer Posted / moorthy g

select count(1) from emp;

Count(1):
14
It will display how many records in emp table
Total 14 Records are there in my table.
Correct If I'm wrong
Regards,
Moorthy

Is This Answer Correct ?    11 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

1845


Implementation methodology

1258


Differentiate between joiner and lookup transformation?

609


What are ETL Tools?

664


Explain the mapping variable usage example in informatica

629






What is meant by lookup transformation? Explain the types of lookup transformation?

565


Why update strategy and union transformations are active?

589


what is the Default Source Option For Update Strategy Transformation?

753


Could you explain what is enterprise data warehouse?

551


How big was your fact table

1310


How can we improve session performance in aggregator transformation?

670


permutations of mapplet

2037


My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

1453


Can we create a node as a gateway node and the same node can be assigned to a grid?

635


Define the various join types of joiner transformation?

557