Optimized query

[Former Member]

Hi ,

I have table in the following format

USERID LDATE LTIME

0000000001 2006.02.09 172005

0000000001 2006.02.09 172055

0000000001 2006.02.09 172224

I need to get the users earlier logon date & time(Only single record). I this case I have to pick up the third record ie 0000000001 2006.02.09 172224

For getting this record how we can use SELECT Single or SELECT UPTO 1 Rows.

My WHERE condition will be like this,

where userid eq lv_userid and

ldate le sy-datum and

ltime lt sy-uzeit.

I Dont want to read all the record by SELECT ENDSELECT and then validate to pickup the latest one ( Since this table will contain huge number of records).

It would be great if anyone higlight a optimized select statement.

BR,

Raj

[Former Member]

Hi raja,

1. U may have to use something like this.

SELECT EBELN MIN( AEDAT ) FROM EKKO

INTO CORRESPONDING FIELDS OF TABLE EKKO

GROUP BY EBELN AEDAT.

in your case.

-

---

SELECT USERID MIN( LDATE ) MIN( LTIME )

FROM DBTABLE

GROUP BY USERID.

3. U can insert your where conditions .

regards,

amit m.

Message was edited by: Amit Mittal