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 / dhiraj

10 because
its return max value of that column.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What encryption security is available in sql azure?

91


What is temporary table in sql server? Why we use temp table?

706


How to view existing indexes on an given table using sys.indexes?

808


How to define and use table alias names in ms sql server?

749


How to insert data with null values?

762


What is the openxml statement in sql server?

736


How will you know when statistics on a table are obsolete?

811


How to see the event list of an existing trigger using sys.trigger_events?

772


What is meant by dirty read?

765


What is your recommendation for a query running very slow? : sql server database administration

776


How to delete an existing database user?

741


What are the differences between having and where clause.

712


What is the user of Primary key?

741


Explain encryption of entire databases without the need for application changes in sql server 2008?

771


what is an index? : Sql server database administration

683