How do u count no of rows in a table?

Answer Posted / amaresh

write this quire "SQL>desc tablename;

Is This Answer Correct ?    2 Yes 14 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What will you get by the cursor attribute sql%rowcount?

645


What are the differences between implicit and explicit cursors?

615


How does sql profiler work?

661


What is the syntax and use of the coalesce function?

711


What is a primary key example?

602






What is the usage of the distinct keyword?

794


What is sql not null constraint?

683


Why indexing is needed?

612


What is acid property in a database?

671


How do I start sql from command line?

615


Explain 3 basic parts of a trigger.

946


Is primary key clustered or nonclustered?

640


what is acid property in database? : Sql dba

659


What is pivot query?

694


How do you rename a table in sql?

633