Selecting Last Row of a Table

[Hassanur]

Hi What will be the SQL SELECT statement to select only the last row of a table. I am using Microsoft SQL server. Please Help me. Tutul

[Anonymous]

Sorry for my english... You should to create a new field (for example "created_on") in your table, which type is TIMESTAMP. When you inserting a new record in the table this field will automatically filled within the time of creation of the new record... So, the request is: SELECT * FROM myTable ORDER BY created_on DESC LIMIT 1

[User 556471]

If the table has a unique ID column (primary key) then u can Select the last record from the table as: Select [Fields Name] from [Table Name] where [Pk Field name] in (Select MAX(Pk Field name) as nID from [Table Name]) e.g., Select employeename,Employee_ID from tbl_emp where Employee_ID in (Select MAX(Employee_id) as nid from tbl_emp) Regards Anyla

[Mandar Patankar]

Hi If you have a date field in your table or some other field which can sort the recordset.If yes then try this SELECT top 1 * FROM tblA ORDER BY DATE1 DESC or SELECT top 1 * FROM tblA ORDER BY DATE1 ASC i hope this helps Mandar Patankar Microsoft Certified professional