Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


Q4. How will you get the count of record without using COUNT verb in query?

Answers were Sorted based on User's Feedback



Q4. How will you get the count of record without using COUNT verb in query?..

Answer / ganesh

select row_number()over() from table_name

Is This Answer Correct ?    8 Yes 5 No

Q4. How will you get the count of record without using COUNT verb in query?..

Answer / sasidharreddy

by using inspect

Is This Answer Correct ?    6 Yes 3 No

Post New Answer

More DB2 Interview Questions

What is db2 instance?

0 Answers  


How does coalesce work?

0 Answers  


DB2 is a A) data base/data communication system B) data base C) RDBMS D) Programming language

4 Answers   Accenture,


What is the physical storage length of date data type?

0 Answers  


Explain the function of data manager.

0 Answers  


What is reorg?

0 Answers  


When will you chose to run RUNSTATS?

1 Answers  


In a single table,How to retrieve a employee-id of an employee who works in more than one department?

15 Answers   Cap Gemini,


what is the process of precompiler?

2 Answers  


What is db2 bind process?

0 Answers  


what is a corelated subquerry?

0 Answers   IBM,


what is a trigger and types of triggers

3 Answers   HSBC,


Categories