With out using count() function. How to the find total
number of rows in a table?
Answer Posted / saurabh
select sum(1) from table-name
Is This Answer Correct ? | 26 Yes | 4 No |
Post New Answer View All Answers
What are inbuilt functions in sql?
How many parts of a pl sql block are optional?
What is a trigger in sql?
What are the various restrictions imposed on view in terms of dml?
What is the difference between cross join and natural join?
what are the advantages of mysql in comparison to oracle? : Sql dba
What does 0 mean in sql?
What is composite primary key in sql?
What is sql*loader and what is it used for?
How can we make an if statement within a select statement?
Show the two pl/sql cursor exceptions.
What is clause in sql?
Describe types of sql statements?
Which normal form is best?
What is the need of merge statement?