how to get the last record only?

senraj · #1 (**permalink**) 08-13-2007, 04:19 AM

This is my Example table structure

code empname salary
A01 S1 7500
A02 S2 5500
A00 S3 6500

how to get the last record only.i will take the single query. pls help me.

Note:All Database(Access,oracle,sql server,MySQL)

Murali · #2 (**permalink**) 08-13-2007, 05:06 AM

In MYSQL

Code:

SELECT * FROM <TableName> ORDER BY <TablePrimaryKeyField> DESC LIMIT 1;

In ORACLE

Code:

SELECT * FROM <TableName> WHERE <TablePrimaryKeyField> =(SELECT MAX(TablePrimaryKeyField> FROM <TableName>);

write2ashokkumar · #3 (**permalink**) 08-13-2007, 07:10 AM

hi...

For Mysql, consider the table name is SAMPLE.

Query to get the last record of the table:

Method 1:

SELECT * FROM SAMPLE ORDER BY _ROWID DESC LIMIT 1;

Method 2:

SELECT * FROM SAMPLE WHERE _ROWID = (SELECT MAX(_ROWID) FROM SAMPLE);

Note : _ROWID is keyword

Regards,
S.Ashokkumar

KiruthikaSambandam · #4 (**permalink**) 08-13-2007, 08:39 AM

Hi,

Use the top and order by.

for example,

select top 1 * from table order by field desc

with regards,
KiruthikaSambandam

kumaresan · #5 (**permalink**) 08-14-2007, 01:14 AM

hi,

There is another way in Mysql to get the last record

HANDLER <tablen-name> OPEN AS <alias>;
HANDLER <alias> READ `primary` last;
handler <alias> close ;

Thanks,
V.Kumaresan.

Jeyaseelansarc · #6 (**permalink**) 08-14-2007, 01:31 AM

hi,
is there any way to get the nth record in mysql?

for example i want to get 3 record from the total of 100 records.
is there any generic way to find it in MySql?

kumaresan · #7 (**permalink**) 08-14-2007, 03:44 AM

Hi ,

To get the N-th row from table in Mysql

SET @N=3; -- for 3rd row from the table
SET @M=@N-1;
SET @S:='SELECT * FROM <Table_Name> LIMIT ?,1';
PREPARE STM FROM @S;
EXECUTE STM USING @M;

--------------
Thanks,
V.Kumaresan.

Murali · #8 (**permalink**) 08-14-2007, 04:13 AM

Quote:

Originally Posted by kumaresan

hi,

There is another way in Mysql to get the last record

HANDLER <tablen-name> OPEN AS <alias>;
HANDLER <alias> READ `primary` last;
handler <alias> close ;

Thanks,
V.Kumaresan.

Could you please clarify the MYSQL Version HANDLER is available?

Got it thanks...

senraj · #9 (**permalink**) 08-24-2007, 11:39 PM

hii guys,

Thanks For
Murali
Ashokkumar
kumaresan
Jeyaseelansarc
KiruthikaSambandam

your answer post.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how can i lock a record id using JSP?	saravanan	Java Server Pages (JSP)	0	03-19-2008 10:03 PM
Audio Record in ASP.NET	kingmaker	ASP and ASP.NET Programming	12	01-08-2008 05:45 AM
How To Record A Phone Conversation With A PC	vadivelanvaidyanathan	Computer Hardware	1	09-18-2007 08:39 AM
Different record methods	Shanthi	Testing Tools	1	08-27-2007 05:50 AM
Difference between ADO.NET dataset and ADO Record set?	prasath	ASP and ASP.NET Programming	1	07-18-2007 08:06 AM