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,

You can use sort statment by Comparing the log on time field. Then you delete the other unwanted entries. So u will have single record with earlier log on time.

Thanks,

Srinivas.