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?
- 2 Answers
- 12825 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / ganesh
select row_number()over() from table_name
| Is This Answer Correct ? | 8 Yes | 5 No |
Post New Answer View All Answers
What is table space in db2?
If I have a view which is a join of two or more tables, can this view be updateable?
What is dbrm library?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
what is a corelated subquerry?
Discuss about db2 bind?
What is blu acceleration in db2?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What is the difference between nvl and coalesce?
What is bind package and plan in db2?
What's The Percentage Free Space ?
How do I create a view in db2?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What is copy pending and check pending in db2?
When reorg is used?
