Answer Posted / manisha
count fetches non-null value from out of a query but count
(*) includes null values also.
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What xml support does the sql server extend?
Tell me about pre-defined functions of sql?
What is the difference between rank and dense_rank?
What happens on checkpoint?
wat wil hapn if we give the both read and deny read permission to user?
What are the disadvantages of using querystrings to send data from one page to another?
Tell me what is difference between view and materialized view?
what is blocking? : Sql server database administration
What are constraints in microsoft sql server?
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
How do I find the default sql server instance?
Are semicolons required at the end of sql statements in sql server 2005?
How to get a list of columns in a view using the "sp_help" stored procedure?
How to provide default values to function parameters?
What is pessimistic concurrency?