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 are the different types of replication you can set up in sql server? : Sql server database administration

768


Explain time data type in sal server 2008?

734


What is left outer join in sql server joins?

717


What is the correct order of the logical query processing phases?

703


What are the restrictions while creating batches in sql server?

780


What is server-level principal?

114


What is the command used to recompile the stored procedure at run time?

808


Why truncate is ddl command?

744


How can you ensure that the database and sql server based application perform well?

817


How can you start sql server in different modes?

737


What do you mean by authentication modes in sql server?

797


Explain the categories of stored procedure?

730


What is b tree index?

689


Which are the new data types introduced in sql server 2008?

689


What is 3nf normalization?

744