Olá caros colegas... estou no sufoco com este SELECT aparentemente simples.. o que eu quero é o seguinte:
Preciso retornar apenas o ultimo registro inserido de cada produto..... exemplo:
NUM_VENDA CODIGO PRODUTO DATA_VENDA VALOR
1578 001 bola azul 12/01/2009 8,65
1577 002 bola verde 11/01/2009 8,65
1576 001 bola azul 10/01/2009 8,65
1575 003 bola preta 13/01/2009 8,65
1574 002 bola verde 10/01/2009 8,65
1573 003 bola preta 09/01/2009 8,65
ou seja, quero retornar apenas o ultimo registro inserido de cada produto, no caso o resultado teria que ser este:
NUM_VENDA CODIGO PRODUTO DATA_VENDA VALOR
1578 001 bola azul 12/01/2009 8,65
1577 002 bola verde 11/01/2009 8,65
1575 003 bola preta 13/01/2009 8,65
por favor, peço a ajuda de voces.
Obrigado!!!
E ai pessoal, alguem se habilita?? estou no sufoco.. me ajudem..
grato!!
Retornar Apenas O Ultimo Registro Incluso
Started By helvis2009, 15/01/2010, 02:32
8 replies to this topic
#1
Posted 15/01/2010, 09:58
#2
Posted 18/01/2010, 12:10
Ok problema resolvido..
Recebi a ajuda em outro forum.. mais fica aqui a solução para quem tem a mesma duvida..
Grato!!
Recebi a ajuda em outro forum.. mais fica aqui a solução para quem tem a mesma duvida..
select * from #teste where NUM_VENDA in ( select MAX(num_venda) from #teste group by CODIGO)
Grato!!
#3
Posted 27/09/2017, 18:38
Canadian Cialis Prices Cialis Cheap Canada cialis Risistance To Amoxicillin Where Can I Buy Ciprobay 500 Mg
Ciao Finasteride Propecia Erfahrungen 777 Tablets Cefotaxime cialis Cialis O Viagra Que Es Mejor Comprar Viagra Generica Foros
Levitra Wirkungsbeginn Viagra Come Doping cialis Access Rx Viagra
Prix Du Viagra Forum Diflucan Price Buy Onadron cialis Cialis 5 Mg Diario
Ciao Finasteride Propecia Erfahrungen 777 Tablets Cefotaxime cialis Cialis O Viagra Que Es Mejor Comprar Viagra Generica Foros
Levitra Wirkungsbeginn Viagra Come Doping cialis Access Rx Viagra
Prix Du Viagra Forum Diflucan Price Buy Onadron cialis Cialis 5 Mg Diario
#4
Posted 09/10/2017, 21:05
Mail Order Synthroid Levitra Online Espana Comprar Levitra Mas Barata cialis price Pharmacy India Online Propecia Afectividad
How Can I Buy Cialis In A Store In Ct viagra online Viagra Soft Deutschland Keflex Chronic Sinus Infection Propecia Alicante
How Can I Buy Cialis In A Store In Ct viagra online Viagra Soft Deutschland Keflex Chronic Sinus Infection Propecia Alicante
#5
Posted 25/10/2017, 09:30
Propecia Does It Work Cialis Cheapest Canada Oxibutuinina viagra Zithromax Dosage
Generique Amoxicillin Pharmacie En Ligne En Germany Cephalexin Class Action levitra sold over the counter Kamagra Oral Jelly Packungsbeilage Cheap Ed Pills
Generique Amoxicillin Pharmacie En Ligne En Germany Cephalexin Class Action levitra sold over the counter Kamagra Oral Jelly Packungsbeilage Cheap Ed Pills
#7
Posted 06/11/2017, 05:12
Preis Cialis 5mg Meilleur Prix Kamagra Oral Jelly Costo Levitra 10 Mg In Farmacia viagra Zithromax 5 Day
Peritol Cyproheptadine Priligy Potenzmittel online pharmacy Wirkung Von Viagra Forum
Pancrelipase Online Synthroid No Prescription viagra Amoxicillin Bladder
Buy Kamagra By Phone Generique Cytotec Cialis Taglich Forum best prices for on line levitra Buy Tamoxifen In Australia
Peritol Cyproheptadine Priligy Potenzmittel online pharmacy Wirkung Von Viagra Forum
Pancrelipase Online Synthroid No Prescription viagra Amoxicillin Bladder
Buy Kamagra By Phone Generique Cytotec Cialis Taglich Forum best prices for on line levitra Buy Tamoxifen In Australia
#8
Posted 05/12/2017, 18:16
Vente De Viagra Sans Ordonnance Pharmacy Viagra Candia cheap cialis Produit 1 Viagra Generique Fiable Lyrica Drug Interactions
Discount Zentel Ups Jnj Priligy Acheter Viagra Dhea buy viagra online Keflex Personality Change Cephalaxin Herstellung Levitra Where Can You Buy Pct Pills?
Levitra Kaufen Berlin viagra Buy Doxycycline Online Fast Delivery
Symptoms Of Amoxicillin Overdose Amoxicillin Joint Pain Where To Purchase Discount Isotretinoin No Prior Script Overseas generic cialis What Size Fluconazole For A Small Dog
Discount Zentel Ups Jnj Priligy Acheter Viagra Dhea buy viagra online Keflex Personality Change Cephalaxin Herstellung Levitra Where Can You Buy Pct Pills?
Levitra Kaufen Berlin viagra Buy Doxycycline Online Fast Delivery
Symptoms Of Amoxicillin Overdose Amoxicillin Joint Pain Where To Purchase Discount Isotretinoin No Prior Script Overseas generic cialis What Size Fluconazole For A Small Dog
#9
Posted 08/11/2022, 10:52
cialis online prescription Five reasons to be optimistic about the future of cancer treatment
1 user(s) are reading this topic
0 membro(s), 1 visitante(s) e 0 membros anônimo(s)