Interested to Buy Any Domain ? << Click Here >> for more details...
what is Difference between Having and Where clause?
- 5 Answers
- 11152 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / ganesh
where clause check a condition & having clause is use in
group by clause
| Is This Answer Correct ? | 12 Yes | 2 No |
Post New Answer View All Answers
What are the sql aggregate functions?
What is the command used to fetch the first 5 characters of a string?
What are sql functions? Describe the different types of sql functions?
which operator is used in query for pattern matching? : Sql dba
Who is the owner of mysql database?
How do I view a view in sql?
Can we update views in sql?
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
What operating systems are supported by oracle sql developer?
Why select is used in sql?
What is blind sql injection?
How to fix oracle error ora-00942: table or view does not exist
First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.
What is column?
What is difference between group by and partition by?
