Help on select a Last Inserted Record

[rajiv07]

Hi to all,
I want to know how to select a last inserted record which is the primary key is not an integer.

my table

ramstr(Primary)----name--service

XTC01-------Rajiv---service

XTC02------kumar--Service

Here i want to select the last inserted record.(XTC02------kumar--Service).

Is any idea Please.

Thanks.
RajivGandhi.

[amitpatel66]

Hi to all,
I want to know how to select a last inserted record which is the primary key is not an integer.

my table

ramstr(Primary)----name--service

XTC01-------Rajiv---service

XTC02------kumar--Service

Here i want to select the last inserted record.(XTC02------kumar--Service).

Is any idea Please.

Thanks.
RajivGandhi.

Try to take the MAX(primary key column) and check if it works??

 
SETEC * from my_table WHERE ramstr = (SELECT MAX(ramstr) FROM my_table);
 
 

[rajiv07]

Try to take the MAX(primary key column) and check if it works??

 
SETEC * from my_table WHERE ramstr = (SELECT MAX(ramstr) FROM my_table);
 
 

It's working fine.Thank You for such a fast reply.

Regards
RajivGandhi

[amitpatel66]

It's working fine.Thank You for such a fast reply.

Regards
RajivGandhi

You are Welcome :)

Amit

[r035198x]

Try to take the MAX(primary key column) and check if it works??

 
SETEC * from my_table WHERE ramstr = (SELECT MAX(ramstr) FROM my_table);
 
 

Wouldn't that give the first value if the key colum is ordered alphabetically?

[amitpatel66]

Wouldn't that give the first value if the key colum is ordered alphabetically?

ORDER BY is basically the way we want the data to be displayed in specific order.

If the value inserted is going to be INCREMENTAL, then MAX will fetch the correct result.

[rajiv07]

Hi to all,

Actually My primary Key Has to be incremented by one With XTC String.Thats why i want to select last inserted record.Suppose my Last record is XTC10 the next record will be XTC11.

Regards
Rajivgandhi

[amitpatel66]

Hi to all,

Actually My primary Key Has to be incremented by one With XTC String.Thats why i want to select last inserted record.Suppose my Last record is XTC10 the next record will be XTC11.

Regards
Rajivgandhi

Then MAX(Primary Key Column) will get you the last inserted record.

[rajiv07]

Hi to all
I have problem finding last inserted record.

my MfqNo (Primary key) column has a values which is incremented by 1 with XTC string for that i want to select the last inserted record But my query is Not working properly;

My MfqNo List

XTC1
XTC2
XTC3
XTC4
XTC5
XTC6
XTC7
XTC8
XTC9
XTC10
XTC11
XTC12
XTC13
XTC14

SELECT  max(mfqno) FROM hq_stock_details where mfqno LIKE 'XTC%';

When I execute this query it return the XTC9 record but i want select XTC14 which is inserted last;How do i do this.

Please Help on this

Thanks
Rajiv

[ronverdonk]

The strict char-value sort order in your case is:

XTC1
XTC10
XTC11
XTC12
XTC13
XTC14
XTC2
XTC3
XTC4
XTC5
XTC6
XTC7
XTC8
XTC9
 

so 9 is the highest, that is correct.

Ronald

[mwasif]

Hi rajiv07,

You can try this, but this will slow things down as table grow.

SELECT * FROM hq_stock_details WHERE MfqNo = (
        SELECT CONCAT('XTC', MAX(CAST(REPLACE(MfqNo, 'XTC','') AS SIGNED))) FROM hq_stock_details
        );

This is one approach, might be there are others :-)

[ronverdonk]

When the number part always starts at position 4, you can do this, i.e. just sorting the numeric part.

SELECT * FROM table by CAST(SUBSTR(column, 4) AS SIGNED);

Ronald

[rajiv07]

Thanks to all Masters,

SELECT * FROM hq_stock_details WHERE MfqNo = (
SELECT CONCAT('XTC', MAX(CAST(REPLACE(MfqNo, 'XTC','') AS SIGNED))) FROM hq_stock_details );

This query is working fine.My integer is not always starting with 4th character.The mfqno has different starting string and different integer position.

Regards
Rajiv.

[mwasif]

Glad to help you. Let us know if you need more help.