Home » RDBMS Server » Server Administration » Re: please answer query
Re: please answer query [message #372708] Sun, 04 March 2001 18:31
Bala
Messages: 205
Registered: November 1999
Senior Member
HI,

select col1, col2....
from tbl1
group by col1, col2...
having count(*) > 1;

Bala.

Report message to a moderator

Previous Topic: DECODE STAMNTS
Next Topic: HOW TO CONVERT NUMBER TO WORD FORMAT WHERE NUMBER HAVING MORE THEN 5373484
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jun 29 08:11:03 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.