What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
- 11 Answers
- 30203 Views
- World Tech, Yardi Software, I also Faced
- E-Mail Answers
Answer Posted / saisri
Where clause is used prior the grouping of data,
where as Having is used after grouping the result of the
data.
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
How to provide default values to function parameters?
How to connect php with different port numbers?
How to convert numeric expression data types using the cast() function?
What are different types of constraints?
How efficient you are in oracle and SQL server?
How to enter binary string literals in ms sql server?
List the ways in which dynamic sql can be executed?
What is standby servers? Explain types of standby servers.
What is sql or structured query language?
Disadvantages of the indexes?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
do you know how to configure db2 side of the application? : Sql server database administration
What is sql server query analyzer?
Can you index views?
