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

Answer Posted / guest

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 command do we use to rename a database?

1014

What is temporary stored procedure?

899

How do I find the query plan in sql server?

909

Suggest a method of joining two tables.

1104

What is acid db?

840

What are trace files?

896

What happens to a trigger with multiple affected rows?

868

Explain table valued parameters in sql server? Why tvp used?

967

What is the difference between a stored procedure and a user defined function?

974

What are partitioned views?

940

List the different types of joins?

929

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

905

What is cross join in sql server joins?

1076

How do you debug a procedure in sql server?

893

What is collation sensitivity?

988