Article View: es.comp.bd.misc
Article #208Consulta SQL
From: Javi (CC)
Date: Tue, 17 May 2005 18:27
Date: Tue, 17 May 2005 18:27
18 lines
1319 bytes
1319 bytes
Buenas, tengo una duda sobre una consulta SQL Tengo una tabla tal que as� Nombre Apellidos telefono Juan Garcia 678 Juan Garcia 852 Juan Garcia 332 Javier Lopez 112 Javier Lopez 258 etc, como har�a para selecionar solo uno de los registros que se repiten por cada persona que tenga el mismo nombre y apellido? Quedar�a as� Juan Garcia 678 Javier Lopez 112 Gracias, un saludo.
Technical Details
Message-ID:
<428a382f_2@newsgate.x-privat.org>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!news.x-privat.net!newsgate.x-privat.org!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Thread: 106e2f,64865c98b5aea50d,start X-Google-Attributes: gid106e2f,public X-Google-Language: SPANISH,ASCII From: "Javi \(CC\)" <gascorbulNOSPAM@hotmail.com> Newsgroups: es.comp.bd.misc Subject: Consulta SQL Date: Tue, 17 May 2005 20:27:54 +0200 Lines: 20 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2527 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527 X-RFC2646: Format=Flowed; Original NNTP-Posting-Host: $$_cwdol$nmnwn2.newsgate.x-privat.org Message-ID: <428a382f_2@newsgate.x-privat.org> Organization: X-Privat NNTP Server - http://www.x-privat.org X-Authenticated-User: $$npfwxo-rsvjdod7n$mxc X-Complaints-To: abuse@x-privat.org Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!news.x-privat.net!newsgate.x-privat.org!not-for-mail