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

Answer Posted / guest

10 because
its return max value of that column .

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is bit datatype? : Sql server database administration

506


What are the properties of primary key?

510


Do you know clustered and non-clustered index?

524


What happens if the update subquery returns no rows in ms sql server?

587


Why use stored procedures in sql server?

554






You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?

99


Define views.

588


What stored by the master? : sql server database administration

575


What does it mean to normalize data?

515


When is update_statistics command used?

583


Explain something about security and SQL Azure?

90


Will count(column) include columns with null values in its count?

666


What is difference between equi join and inner join?

482


How to rename an existing column with sql server management studio?

496


What is a constant or literal in ms sql server?

592