what is difference between where clause and having clause?
Answers were Sorted based on User's Feedback
Answer / mrityunjay kumar dubey
A WHERE Clause is used to restrict a row and HAVING Clause is used to restrict a group.WHERE Clause can be used for specifying the search criteria in SELECT, DELETE, UPDATE statements.HAVING Clause is used when GROUP BY Clause is used.
Is This Answer Correct ? | 0 Yes | 2 No |
Answer / manvendra
RISTRICT GROUP BY FUNCTION BY HAVING.
RESTRICT NORMAL QUERY BY WHERE.
YOU CAN PUT WHERE AND HAVING IN A QUERY.
Is This Answer Correct ? | 14 Yes | 21 No |
Answer / pawan
HAVING clause is used only with GROUP functions whereas
WHERE clause we can use with both.
Is This Answer Correct ? | 8 Yes | 15 No |
What are the different windows events activated at runtime ?
I know that i can create a table without a primary key.But is there any significance for that table???? while creating an application.
What is the difference between view and materialized view in Oracle?
How to retrieve data from an cursor to a record?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
How many different types of indexes we have in oracle?
24 Answers IBM, TCS,
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
How to run create database statement?
What is the purpose of init.ora. ? how many init.ora exist in oracle installation? suppose there are 3 database on one oracle server, how many init.ora do I have? what are various database objects? how will you identify memmory related performace issue in oralce? any idea about basic architure difference of oracle and db2? comment on which is better , with reasons? what is a fuction based index? is it recommended to use the same. ? what is global temporay table? what is teh signification of the parameter session_cached_cursor ?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
how to get last monday of a month?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?