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

Delete duplicate rows without using rowid.

0 Answers   Nagarro,


What are the different types of lock modes in sql server 2000?

0 Answers  


How to trouble shoot if unable to connect SQL Server

0 Answers  


Explain SELF JOIN ?

3 Answers   ADP,


What are user defined datatypes and when you should go for them?

1 Answers  






What is the sql profiler?

0 Answers  


Explain the benefits of user-defined functions?

0 Answers  


Can primary key be null?

0 Answers  


wat is the main diff between sql server 2000and sql server 2005

6 Answers   Jade Software,


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

0 Answers  


What is user stored procedure & it purpose?

4 Answers   Wipro,


How many triggers are possible per table?

0 Answers  


Categories