10 because its return max value of that column. interviewer wants to ch

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

Question Posted / sudhakar

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

What do you understand by physical_only option in dbcc checkdb?

1026

explain different levels of normalization? : Sql server database administration

1051

I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

1138

How to change server name in sql server?

1254

Where are stored procedures in sql server?

1129

How do I start and stop sql server?

1064

List the various tools available for performance tuning?

927

Explain about builtinadministrator?

1117

What are the different types of columns types constraints in the sql server?

1135

Explain what is cte (common table expression)?

1191

How to provide default values to stored procedure parameters?

1105

What is the difference between for trigger and after trigger?

1164

Tell me what are the essential components of sql server service broker?

991

What is federation member?

116

What are the properties of the transaction?

1052