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
What is native sql query?
How do I find duplicates in a single column in sql?
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
Which join is like an inner join?
What is user defined functions?
what are the different tables present in mysql? : Sql dba
what is a control file ? : Sql dba
What are data types in pl sql?
How to create a menu in sqlplus or pl/sql?
Does group by remove duplicates?
How to avoid using cursors?
What is the left table in sql?
What are reports usually used for?
Is primary key clustered index?
Is natural join same as inner join?