What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
Answer Posted / sararh
where clause uesd for the fiend out particulater records and
where clause u write after select statement.
Having clause used for combination of group by functions
with out group by function u can nit write the having caluse.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain why variables called the most powerful component of ssis?
explain extended properties
What do you understand by coalesce in sql server?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
What is a constant or literal in ms sql server?
Where can you find the error log information? : sql server database administration
Explain about extended stored procedure?
Explain about temporary stored procedure?
What are the purposes and advantages stored procedure?
What is a benefit of using an after insert trigger over using a before insert trigger?
what are defaults? Is there a column to which a default can't be bound? : Sql server database administration
what is denormalization and when would you go for it? : Sql server database administration
Explain data warehousing in sql server?
How do you size a resultset?
What are the new features in SQL Server 2005 when compared to SQL Server 2000?