what is difference between where clause and having clause?
Answer Posted / rajesh dutta
where conditions used only for comparing row values.
having conditions used to compares group values like
min,max,count etc.
Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
What is PL/SQL ?
What is oracle latest version?
What is an index associated with a constraint?
What is the difference between a hot backup and a cold backup in oracle?
What is the purpose of save points in oracle database?
Can we use bind variables in oracle stored procedure?
What is a snapshot log?
How do we display rows from the table without duplicates?
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
When do you get a .pll extension in oracle?
What do you mean by group by clause?
Can we create trigger on materialized view in oracle?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
Which are the five query types available in oracle?
What is a subquery in oracle?