1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

How to find the last update record in SQL Server?

Question Posted / k.sridharan

Answers were Sorted based on User's Feedback



How to find the last update record in SQL Server?..

Answer / ravindra

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

Is This Answer Correct ?    17 Yes 18 No

How to find the last update record in SQL Server?..

Answer / sneha

uisng current .........

Is This Answer Correct ?    4 Yes 17 No

How to find the last update record in SQL Server?..

Answer / balaji.p

select ident_current(column) from table name

Is This Answer Correct ?    2 Yes 17 No

How to find the last update record in SQL Server?..

Answer / anil kumar

Select max(<columnname>) from <tablename>;

Is This Answer Correct ?    10 Yes 38 No

Post New Answer

More SQL Server Interview Questions

What is the use of tempdb? What values does it hold?

0 Answers   Abacus,

What are the differences between user defined functions and stored procedures?

0 Answers  

Why use “nolock” in sql server?

0 Answers  

Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

0 Answers   Crown Solutions,

What is table-valued sub query?

0 Answers  




What is temporal data type?

0 Answers  

What is after dml trigger?

0 Answers  

What is Trigger?

3 Answers   Misys,

Explain the various types of concurrency problem?

0 Answers  

What are the different sql server versions?

0 Answers  

What are the different SQL Server Versions you have worked on?

0 Answers  

How to get the definition of a trigger back?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories