Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

need sql query?

3 Posts 2 Posters 0 Views 1 Watching

M Offline
M Offline
murali_utr

wrote on last edited by

#1

Hi, table containing two fields one is code and another is name. i need to fetch repeated names only.(more than one occurance of name and code is not same). any one help to me. thanks in advance. Have A Nice Day! Murali.M
S 1 Reply Last reply

0
M murali_utr

Hi, table containing two fields one is code and another is name. i need to fetch repeated names only.(more than one occurance of name and code is not same). any one help to me. thanks in advance. Have A Nice Day! Murali.M
S Offline
S Offline
stefan b

wrote on last edited by

#2

SELECT name FROM table GROUP BY name HAVING COUNT(name)>1 Cheers, _____________ stefan bornuz
M 1 Reply Last reply

0
S stefan b

SELECT name FROM table GROUP BY name HAVING COUNT(name)>1 Cheers, _____________ stefan bornuz
M Offline
M Offline
murali_utr

wrote on last edited by

#3

hi stefan, thanks for ur help. Have A Nice Day! Murali.M
1 Reply Last reply

0

Log in to reply