Waseem Mehmood

 Profile Answers by Waseem Mehmood Questions by Waseem Mehmood

• Jun 2nd, 2011

Select ename, count(ename) Count From emp Group by ename Having count(ename) > 1 ;

Showstopper

 Profile Answers by Showstopper Questions by Showstopper

• Jun 21st, 2010

We can count the duplicate entry in particular table by using the following queryselect count(*)from a bwhere exists (select rowid           &nbs...

Answer Question  Select Best Answer

A subquery within a subquery

velur1

 Profile Answers by velur1 Questions by velur1

• Sep 19th, 2008

A query within a subquery

rjk1203

 Profile Answers by rjk1203 Questions by rjk1203

• Sep 19th, 2008

A Correlated Subquery which executes with value returned by the child Query. Unlike subquery it executes per result from child query.Ex: removing duplicate rows from a table Subquery executes once for the entire child query's result

Answer Question  Select Best Answer