sql babulu ravali - urgent helf

[nenu_devudni]

869997    54BLL     KL    1.1.1.8.0.255    62075    11/17/2016 1:48:00 AM      SUSR    11/17/2016 7:37:06 AM
869997    54BLL    KL    1.1.1.8.0.255    62055    11/16/2016 1:48:00 AM    SUSR    11/16/2016 7:37:01 AM
869997    54BLL    KL    1.1.1.8.0.255    62055    11/16/2016 1:48:00 AM    SUSR    11/16/2016 10:05:17 AM
869997    54BLL    KL    1.1.1.8.0.255    62055    11/16/2016 1:48:00 AM    SUSR    11/16/2016 11:27:19 AM
869997    54BLL     KL    1.1.1.8.0.255    62019    11/14/2016 1:48:00 AM     SUSR    11/14/2016 7:36:57 AM
869997    54BLL    KL    1.1.1.8.0.255    61969    11/13/2016 1:48:00 AM     SUSR    11/14/2016 7:36:57 AM
 

meru ekada chuste .. 16th roju multiple rows ochay .. vetini max date toh compare sesi oke unique record oche la cheyali ... max date ani conditon pedithe .. oke record return avtundi .. ala kakunda duplicates poi migita records kuda return avali .. 

na process ki  869997  and KL ane  2 values ni param ga pass chestunaru .. .so ipudu matter endi ante .. max date ani where clause lo use chesi anni records ela return cheyali .. 

[nenu_devudni]

[nenu_devudni]

[4Vikram]

Ltt for you God man... Na Number unte okasari ping cheyu, help cheyalenu naak help kavali ante adagadanki

[nenu_devudni]

5 minutes ago, 4Vikram said:

Ltt for you God man... Na Number unte okasari ping cheyu, help cheyalenu naak help kavali ante adagadanki

vikki thatha etla unay nuvu ... na num ichina kada vay .... pm sesssa .. susko ..  em sesinav thatha nek pm potle ..

[Srimantudu]

3 minutes ago, nenu_devudni said:

vikki thatha etla unay nuvu ... na num ichina kada vay .... pm sesssa .. susko .. 

Date <= todays date iste ? with distinct 

[chicchara]

neeku resultant set ela undaaloo kuda post chey..

ur post is a little confusing

[Srimantudu]

1 minute ago, chicchara said:

neeku resultant set ela undaaloo kuda post chey..

ur post is a little confusing

I think he is asking for 

869997    54BLL     KL    1.1.1.8.0.255    62075    11/17/2016 1:48:00 AM      SUSR    11/17/2016 7:37:06 AM

869997    54BLL    KL    1.1.1.8.0.255    62055    11/16/2016 1:48:00 AM    SUSR    11/16/2016 10:05:17 AM

869997    54BLL    KL    1.1.1.8.0.255    61969    11/13/2016 1:48:00 AM     SUSR    11/14/2016 7:36:57 AM

[chicchara]

869997    54BLL     KL    1.1.1.8.0.255    62075    11/17/2016 1:48:00 AM      SUSR    11/17/2016 7:37:06 AM
869997    54BLL    KL    1.1.1.8.0.255    62055    11/16/2016 1:48:00 AM    SUSR    11/16/2016 7:37:01 AM
869997    54BLL    KL    1.1.1.8.0.255    62055    11/16/2016 1:48:00 AM    SUSR    11/16/2016 10:05:17 AM
869997    54BLL    KL    1.1.1.8.0.255    62055    11/16/2016 1:48:00 AM    SUSR    11/16/2016 11:27:19 AM
869997    54BLL     KL    1.1.1.8.0.255    62019    11/14/2016 1:48:00 AM     SUSR    11/14/2016 7:36:57 AM
869997    54BLL    KL    1.1.1.8.0.255    61969    11/13/2016 1:48:00 AM     SUSR    11/14/2016 7:36:57 AM

 

aa red vi poyi neeku result lo 11/13, 11/14, 11/16-1 record, 11/17 raavala?

and anni columns ravala? result set lo

[nenu_devudni]

11 minutes ago, 4Vikram said:

u got my point vuncle .. exactly alage result set undali 

[mettastar]

rank chesi first rank unadi pick chesko vuncle

[Hyper]

[nenu_devudni]

kadu vuncle .. 14th, 16th and 17th ki unqiue records undali ... 16th roju multiple records unay  .. so andulo max date esi oka record oche la cheyali .. 

[Srimantudu]

1 minute ago, mettastar said:

rank chesi first rank unadi pick chesko vuncle

 

[nenu_devudni]

3 minutes ago, Srimantudu said:

 

rank este anitiki oke rank ostundi thatha  ... nenu select cheyatledu fields ni .. where clause lo fix cheyali  because i am displaying this data in a oracle form...