what is difference between where clause and having clause?
Answer Posted / 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 |
Post New Answer View All Answers
What is blob datatype?
How to list all tables in your schema?
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
What is a trigger and what are its types in oracle?
What is the string concatenation operator in oracle?
What are the different types of database objects?
What happens if you lost a data file?
How to assign values to data fields in record variables?
What are the predefined tablespaces in a database?
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
What is a cognitive schema?
What is the difference between online and offline backups?
How to write date and time literals in oracle?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
What is ordinary table in oracle?