I hav 10 records only one column
1,2,3,4,5......10
now am writing query select max(column name)
Then
What is The Output
Answer Posted / shyamsri83
The Maximum column value will be the output.
10
| Is This Answer Correct ? | 30 Yes | 0 No |
Post New Answer View All Answers
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
Name few endpoints exposed by ssrs 2012?
Types of Authentications in Sql Server? How user gets authenticated through windows authentication?
How do I view a script in sql server?
How to list all field names in the result set using mssql_field_name()?
How to generate create table script on an existing table in ms sql server?
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation
What is a deadlock and what is a live lock?
How to loop through the result set with @@fetch_status?
what protocol both networks use? : Sql server database administration
Define inner join? Explain with an example?
Explain full-text query in sql server?
What is log shipping?
Tell me what is sql profiler?
Does sql server use java?