List the ways to get the count of records in a table?
- 1 Answers
- 978 Views
- I also Faced
- E-Mail Answers
Answer Posted / Shubham Gangwar
In SQL, you can use COUNT(), COUNT(*) (counts non-null values), and COUNT(distinct column_name) to get the count of records in a table.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can we rollback truncate?
Does group by remove duplicates?
what is collation? : Sql dba
Can delete statement be rollbacked?
define sql insert statement ? : Sql dba
Do we need to rebuild index after truncate?
what are all the common sql function? : Sql dba
how to use regular expression in pattern match conditions? : Sql dba
What is your daily office routine?
How do I remove duplicates in two columns?
Can we use distinct and group by together?
What is the current version of postgresql?
Is primary key clustered index?
Is inner join faster than left join?
what is dbms? : Sql dba
