What does “select count(*) from tab” result?
Answer Posted / brajesh kr.
select count(1) from table. will return values without null
values. count(*) will return values aceept null also.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Explain correlated query work?
Write the alter statement to enable all the triggers on the t.students table.
Why should I use postgresql?
what are set operators in sql? : Sql dba
Why we use triggers in mysql?
How can get second highest salary in sql?
Can procedure in package be overloaded?
What are different types of triggers?
Are dml statements autocommit?
Mention what are different methods to trace the pl/sql code?
When is a declare statement required?
What operators deal with null?
What is a table partition?
What is pivot query?
What are sql constraints?