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

output will be 10.

Is This Answer Correct ?    14 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?

794


What are the types of joins in sql?

777


What are the main differences between #temp tables and @table variables and which one is preferred?

771


in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

739


How to declare a cursor with "declare ... Cursor" in ms sql server?

741






What are the kinds of subquery?

710


What is the use of nvl work?

721


What is sql server transaction log file?

709


What is a unique index?

674


How is sql used in sql server?

672


Will sql server 2005 allow you to reduce the size of a column?

704


What are a scheduled jobs or what is a scheduled tasks?

655


How to use clusters?

695


What is the difference between functions and stored procedures?

796


How to use subqueries in the from clause in ms sql server?

806