Hi Mathur,
I would like to help you just I need some more details...
from this:
SELECT AmtAfter, AcctID FROM Usr_AmtDetailsOrder By AcctRecharged
Data Retrieved by the Query:AmtAfter AcctId
2006.12 000280196
4006.12 000280196
0.00 002101839
1000.55 002107518
1001.24 002107518
1012.92 002107518
1242.25 002107518
996.53 002107518
999.49 002107518
1590.02 002107582
You probably need this:
2006.12 000280196
0.00 002101839
1000.55 002107518
1590.02 002107582
am I correct? Can you please create result: select * from Usr_AmtDetails
we need to see the rest maybe you have something to make "WHERE"
Other is that each table have one more field like record number... in this you should use max(recno...) to have the latest input...
Senad Sabanovic
----- Original Message ----
From: Ankit Mathur <ankitmathur82@xxxxxxxxxxx>
To: "php-objects@xxxxxxxxxxxxxxx" <php-objects@xxxxxxxxxxxxxxx>
Sent: Wednesday, January 23, 2008 7:50:27 AM
Subject: Please help with a SQL Query
Hi Friends,I'm sorry again for the third post but I'm trying to place the Query Data Properly but its formatting is lost everytime the mail is sent.
I've been looking for an answer to this problem for quite sometime but an unable to find one.I hope someone from group can help me guide to the right way.Here's my SQL Query:SELECT AmtAfter, AcctID FROM Usr_AmtDetailsOrder By AcctRecharged
Data Retrieved by the Query:AmtAfter AcctId
2006.12 000280196
4006.12 000280196
0.00 002101839
1000.55 002107518
1001.24 002107518
1012.92 002107518
1242.25 002107518
996.53 002107518
999.49 002107518
1590.02 002107582Data I want:AmtAfter AcctId2006.12 000280196
0.00 002101839
1000.55 002107518
1590.02 002107582
Basically, I want only the latest entry of an distinct accountids & not the rest of the records also.Can someone guide me to a solution.ThanksAnki t Mathur
____________ _________ _________ _________ _________ _________ _
Post free property ads on Yello Classifieds now! www.yello.in
http://ss1.richmedi a.in/recurl. asp?pid=220
[Non-text portions of this message have been removed]
<!--
#ygrp-mkp{
border:1px solid #d8d8d8;font-family:Arial;margin:14px 0px;padding:0px 14px;}
#ygrp-mkp hr{
border:1px solid #d8d8d8;}
#ygrp-mkp #hd{
color:#628c2a;font-size:85%;font-weight:bold;line-height:122%;margin:10px 0px;}
#ygrp-mkp #ads{
margin-bottom:10px;}
#ygrp-mkp .ad{
padding:0 0;}
#ygrp-mkp .ad a{
color:#0000ff;text-decoration:none;}
-->
<!--
#ygrp-sponsor #ygrp-lc{
font-family:Arial;}
#ygrp-sponsor #ygrp-lc #hd{
margin:10px 0px;font-weight:bold;font-size:78%;line-height:122%;}
#ygrp-sponsor #ygrp-lc .ad{
margin-bottom:10px;padding:0 0;}
-->
<!--
#ygrp-mlmsg {font-size:13px;font-family:arial, helvetica, clean, sans-serif;}
#ygrp-mlmsg table {font-size:inherit;font:100%;}
#ygrp-mlmsg select, input, textarea {font:99% arial, helvetica, clean, sans-serif;}
#ygrp-mlmsg pre, code {font:115% monospace;}
#ygrp-mlmsg * {line-height:1.22em;}
#ygrp-text{
font-family:Georgia;
}
#ygrp-text p{
margin:0 0 1em 0;}
#ygrp-tpmsgs{
font-family:Arial;
clear:both;}
#ygrp-vitnav{
padding-top:10px;font-family:Verdana;font-size:77%;margin:0;}
#ygrp-vitnav a{
padding:0 1px;}
#ygrp-actbar{
clear:both;margin:25px 0;white-space:nowrap;color:#666;text-align:right;}
#ygrp-actbar .left{
float:left;white-space:nowrap;}
.bld{font-weight:bold;}
#ygrp-grft{
font-family:Verdana;font-size:77%;padding:15px 0;}
#ygrp-ft{
font-family:verdana;font-size:77%;border-top:1px solid #666;
padding:5px 0;
}
#ygrp-mlmsg #logo{
padding-bottom:10px;}
#ygrp-vital{
background-color:#e0ecee;margin-bottom:20px;padding:2px 0 8px 8px;}
#ygrp-vital #vithd{
font-size:77%;font-family:Verdana;font-weight:bold;color:#333;text-transform:uppercase;}
#ygrp-vital ul{
padding:0;margin:2px 0;}
#ygrp-vital ul li{
list-style-type:none;clear:both;border:1px solid #e0ecee;
}
#ygrp-vital ul li .ct{
font-weight:bold;color:#ff7900;float:right;width:2em;text-align:right;padding-right:.5em;}
#ygrp-vital ul li .cat{
font-weight:bold;}
#ygrp-vital a{
text-decoration:none;}
#ygrp-vital a:hover{
text-decoration:underline;}
#ygrp-sponsor #hd{
color:#999;font-size:77%;}
#ygrp-sponsor #ov{
padding:6px 13px;background-color:#e0ecee;margin-bottom:20px;}
#ygrp-sponsor #ov ul{
padding:0 0 0 8px;margin:0;}
#ygrp-sponsor #ov li{
list-style-type:square;padding:6px 0;font-size:77%;}
#ygrp-sponsor #ov li a{
text-decoration:none;font-size:130%;}
#ygrp-sponsor #nc{
background-color:#eee;margin-bottom:20px;padding:0 8px;}
#ygrp-sponsor .ad{
padding:8px 0;}
#ygrp-sponsor .ad #hd1{
font-family:Arial;font-weight:bold;color:#628c2a;font-size:100%;line-height:122%;}
#ygrp-sponsor .ad a{
text-decoration:none;}
#ygrp-sponsor .ad a:hover{
text-decoration:underline;}
#ygrp-sponsor .ad p{
margin:0;}
o{font-size:0;}
.MsoNormal{
margin:0 0 0 0;}
#ygrp-text tt{
font-size:120%;}
blockquote{margin:0 0 0 4px;}
.replbq{margin:4;}
-->
____________________________________________________________________________________
Looking for last minute shopping deals?
Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping
[Non-text portions of this message have been removed]
