two tables with table name ship(name,year) and battle (name,year),how to find t

two tables with table name ship(name,year) and battle
(name,year),how to find the latest added year in the table
ship

Question Posted / prithiba

two tables with table name ship(name,year) and battle (name,year),how to find the latest added year..

Answer / challa yerriswamy

by using timestamp data type

Is This Answer Correct ?

3 Yes

1 No

More SQL Server Interview Questions

what are the new features introduced in sql server 2000? : Sql server database administration

How create table structure only from tableA to TableB if TableA have some data?

Define full outer join in sql server joins?

What is @@error in sql?

What does select 1 mean?

Can a synonym name of a table be used instead of a table name in a select statement?

What is difference between commit and rollback when used in transactions?

What is difference between standardization and normalization?

How to Handle the exceptions in Sqlsrver 2005??

How to find out what is the default collation in a database?

Explain forward - only cursors?

How to truncate a table first before running a package?

For more SQL Server Interview Questions Click Here