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

How does a profiler work?

870

what are isolation levels? : Sql server database administration

911

When does a workload on SQL Azure get throttled?

129

Do you know what is a trace frag? Where do we use it?

955

Can you explain important index characteristics?

938

How to delete existing rows in a table?

1071

what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

955

What is parameterized reports in ssrs ?

141

How to write a query with a full outer join in ms sql server?

999

How to get nth highest salary from employee table.

1103

Tell me what is log shipping?

935

What do you understand by the analysis services in sql server?

890

What do you mean by sql server 2005 express management tools?

1251

How to retrieve error messages using mssql_get_last_message()?

992

how will add additional conditions in sql?

1013