10 because its return max value of that column.

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

Answer Posted / dhiraj

10 because
its return max value of that column.

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is function of ROLLUP ?

1145

Which is the latest version of sql server and when it is released?

1201

Explain mixed authentication mode of sql server?

1121

Are resultset updatable?

1010

What are difference between Cluster index and Non-Cluster index?

1133

How does stuff differ from the replace function?

1064

what is memory-optimized nonclustered indexes

1065

What is inner join? Explain with an example?

1287

explain how to create a new schema in a database? : Sql server database administration

1159

Where are full-text indexes stored?

1037

Can we use pragma autonomous_transaction in trigger?

1015

what is a transaction? : Sql server database administration

1053

What is ddl command?

1035

What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

1260

How do you handle datasets larger than 50 gb?

164