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

Please get the 4 th maximum salary from a table without using any sql keyword (TOP,MAX are mot allowed)

8 Answers  


What is the purpose of the model database?

0 Answers  


Do you know what is openxml in sql server?

0 Answers  


Can you pass expressions to stored procedure parameters?

0 Answers  


when would you go for denormalization? : Sql server database administration

0 Answers  






Explain about system stored procedure?

0 Answers  


What are the different types of indexes?

0 Answers   Blue Star,


HOW TO RENAME A COLUMN NAME

3 Answers  


What is Schema? and why we use schemas?

4 Answers  


What guidelines should be followed to help minimize deadlocks?

0 Answers  


Write a SQL queries on Self Join and Inner Join.

0 Answers   Aspiring Minds,


What is a SQL Server Temporary Table?

1 Answers   Wipro,


Categories