how do u know the total no of rows in a table?

Answer Posted / javid khan

select count(*) from table;

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Give syntax for SQL and ORACLE joins.

628


How to count groups returned with the group by clause in oracle?

572


When do you get a .pll extension in oracle? Explain its importance

572


What is primefaces used for?

557


What the is the diff between local index and global index. give some example.

1133






How do I know if oracle client is installed on windows?

494


is there a tool to trace queries, like profiler for sql server?

595


what is dynamic SGA and static SGA

3832


What are advantages of dateset in datastage?

1744


Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

1652


How to connect to the server with user account: sys?

560


What is control file used for?

600


Explain user account with reference to oracle.

528


hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.

1754


What is coalesce function?

569