-
HAVING vs WHERE Clause
Where clause restricts rows, what does having clause restricts ?1. only group results.2. rows results.3. both rows and groups result.
Read Best Answer
Editorial / Best Answer
ajaysinghnegi- Member Since Mar-2009 | Mar 27th, 2009
1) HAVING clause can only be used to filter out the aggegate functions whereas WHERE clause cannot filter out the aggegate functions.
2) HAVING clause can be used with GROUP BY function where as WHERE clause cannot be used with group by function.gubba123
- Aug 8th, 2010
Example: Write a query to display the Managers who are working for more than one Departments:Select emp_id, count(distinct dept_id) From emp Where...
Tartauris
- Feb 16th, 2010
Having is used for agregate results while where is used for unagregated results.
-
write a query to update third column such that
There is a table having the following columns :-student id marks1 marks2 maxmarks1 10 20 202 25 30 303 30 10 304 35 25 355 20 40 40write a query to update column maxmarks such that maxmarks column contains whatever be the greater value among marks1...
indra.prasad
- Jul 12th, 2010
CREATE TABLE aa(name varchar(10), marks1 int, marks2 int, maxmarks int);INSERT INTO aa VALUES ('a',10,20,null);INSERT INTO aa VALUES ('b',20,25,null);UPDATE aa SET maxmarks= CASE WHEN marks1 > marks2 THEN marks1 ELSE marks2 END;
Palash Biswas
- May 20th, 2010
Declare @tbl_Test TABLE([Name] Nvarchar(255),Mark1 int,mark2 int,maxmark int) Insert into @tbl_Test([Name] ,Mark1 ,mark2) VALUES ('a',50,20) Insert into @tbl_Test([Name] ,Mark1 ,mark2) VALUES ('b',10,...
-
Suppose a customer table is having different columns like customer no, payments.What will be the query to select top three max payments?
SELECT customer_no, payments from customer C1WHERE 3<=(SELECT COUNT(*) from customer C2WHERE C1.payment <= C2.payment)
ankitagujrati28
- May 3rd, 2010
Select rownum,cust_no,payments from (select cust_no,payments from customerwhere rownum<4order by payments desc);
thirupathireddy
- Feb 2nd, 2010
SELECT rownum "rank", customer_no, payments FROM (SELECT customer_no, paymentsFROM customer ORDER BY payments DESC)WHERE rownum <4;
-
Which is more faster - IN or EXISTS?
EXISTS is more faster than IN because EXISTS returns a Boolean value whereas IN returns a value.
rohitosu
- Mar 9th, 2012
As a rule of thumb IN should be used when the sub query will return small result set. It should be kept in mind that the sub query should not return null values. EXISTS should be used when the result set returns large result set. Other factors that might affect query performance is the indexes
Vineet Arya
- Sep 17th, 2011
Which is more faster - IN or EXISTS? It totally depends upon the query. For some queries Exist is efficient and for some IN is efficient Exits is correlated sub query, in which the outer query run f...
-
There is a string 120000 12 0 .125 , how you will find the position of the decimal place?
INSTR('120000 12 0 .125',1,'.')output 13
-
How will you delete duplicating rows from a base table?
delete from table_name where rowid not in (select max(rowid) from table group by duplicate_values_field_name); ordelete duplicate_values_field_name dv from table_name ta where rowid <(select min(rowid) from table_name tb where ta.dv=tb.dv);
thirupathireddy
- Feb 2nd, 2010
DELETE FROM table_name a WHERE rowid > (SELECT min(rowid) FROM table_name b WHERE a.column_name=b.column_name)
syam sundar
- Aug 18th, 2007
Delete table_name t1where rowid>(select rowid from table_name t2)and t1.column1=t2.column1
-
What is a view ?
A view is stored procedure based on one or more tables, it�s a virtual table.
Suresh Babu Nallamothu
- Nov 8th, 2018
A view is a virtual table,Because it doesn't have its own data and it doesn't occupy the database memory.
ankitagujrati28
- Apr 30th, 2010
A view is a mirror image of one or more table. View provides data access privilages.
-
What is difference between Rename and Alias?
Rename is a permanent name given to a table or column whereas Alias is a temporary name given to a table or column which do not exist once the SQL statement is executed.
-
What are different Oracle database objects?
TABLESVIEWSINDEXESSYNONYMSSEQUENCESTABLESPACES etc
suresh
- Mar 13th, 2015
Table,view,procedure,function,package,synonums,triggers,index,sequencess
-
What are various constraints used in SQL?
NULLNOT NULLCHECKDEFAULT
-
What are various joins used while writing SUBQUERIES?
Self join-Its a join foreign key of a table references the same table. Outer Join--Its a join condition used where One can query all the rows of one of the tables in the join condition even though they don't satisfy the join condition.Equi-join--Its a join condition that retrieves rows from one or more tables in which one or more columns in one table are equal to one or more columns in the second table.
Santhoshkandula
- May 11th, 2011
There are 5 types of joins. Those are 1. Equi Join / Inner Join 2. Non-Equi Join 3. Outer Join ( Left Outer Join, Right Outer Join, Full Outer Join ) 4. Self Join 5. Cross Join
