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

Answers were Sorted based on User's Feedback



I hav 10 records only one column 1,2,3,4,5......10 now am writing query select max(column name) T..

Answer / shyamsri83

The Maximum column value will be the output.
10

Is This Answer Correct ?    30 Yes 0 No

I hav 10 records only one column 1,2,3,4,5......10 now am writing query select max(column name) T..

Answer / bhagat

output will be 10.

Is This Answer Correct ?    14 Yes 0 No

I hav 10 records only one column 1,2,3,4,5......10 now am writing query select max(column name) T..

Answer / sudhakar

10 because
its return max value of that column. interviewer wants to
check you r confidance so thats he confused you .

Is This Answer Correct ?    5 Yes 0 No

I hav 10 records only one column 1,2,3,4,5......10 now am writing query select max(column name) T..

Answer / deekshith reddy

10

Is This Answer Correct ?    3 Yes 0 No

I hav 10 records only one column 1,2,3,4,5......10 now am writing query select max(column name) T..

Answer / ravikumarayyapu

Output is 10.

Is This Answer Correct ?    3 Yes 0 No

I hav 10 records only one column 1,2,3,4,5......10 now am writing query select max(column name) T..

Answer / guest

10 because
its return max value of that column .

Is This Answer Correct ?    2 Yes 0 No

I hav 10 records only one column 1,2,3,4,5......10 now am writing query select max(column name) T..

Answer / guest

10 because
its return max value of that column .

Is This Answer Correct ?    2 Yes 0 No

I hav 10 records only one column 1,2,3,4,5......10 now am writing query select max(column name) T..

Answer / dhiraj

10 because
its return max value of that column.

Is This Answer Correct ?    2 Yes 0 No

I hav 10 records only one column 1,2,3,4,5......10 now am writing query select max(column name) T..

Answer / swapna

The output is 10

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More SQL Server Interview Questions

how to generate XML out of QUERY?

1 Answers   McAfee,


How can a user-defined datatype be created?

0 Answers  


What does man by sql wildcard characters in sql server?

0 Answers  


what is the maximum size of a row? : Sql server database administration

0 Answers  


What is mssql?

0 Answers  






How to replace null values in expressions using isnull()?

0 Answers  


How to list all columns in a table using odbc_columns()?

0 Answers  


List some of the rules that apply to creating and using a ‘view’

0 Answers  


How many types of Outer Joins?What are they?

1 Answers  


Explain full-text indexing?

0 Answers  


What is forward - only cursors / read only cursor?

0 Answers  


What is a domain constraint give an example?

0 Answers  


Categories