Select top 1 <Col-name> from <table> order by RecordTime desc

How to find the last update record in SQL Server?

Question Posted / ravindra

Answer Posted / ravindra

Select top 1 <Col-name> from <table> order by RecordTime
desc

Is This Answer Correct ?

17 Yes

18 No

Please Help Members By Posting Answers For Below Questions

Can we insert data if clustered index is disabled?

934

What are the High-Availability solutions in SQL Server and differentiate them briefly?

1134

How to create database with physical files specified in ms sql server?

986

What is sub query and its properties?

970

What is open database communication (odbc)?

1054

What were the latest updates to SQL Azure service?

111

What is the maximum size of a dimension? : sql server analysis services, ssas

1035

How to provide values to stored procedure parameters in ms sql server?

1024

how to use DTS package in 2000,2005,2008 in sql server

1828

How can I get data from a database on another server?

981

What is data compression? : sql server database administration

961

Explain the difference between HTTP and HTTPS in database?

1022

Please illustrate physical database architecture? : SQL Server Architecture

973

What is a domain constraint give an example?

1035

How you can change the database name in SQL SERVER?

1186