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

The Maximum column value will be the output.
10

Is This Answer Correct ?    30 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is similarity and difference between truncate and delete in sql?

802


What is dbcc command in sql server?

791


Does server sql treat char as a variable-length or fixed-length column?

794


How to delete database objects with "drop" statements in ms sql server?

786


Where views are stored in sql server?

736


When you should use a low fill factor?

733


Explain the xml support sql server extends?

824


How to change a login name in ms sql server?

727


What is normalization? What number of normalization shapes are there?

819


Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

1704


Define clusters?

823


What are the export options of ssrs?

151


How global temporary tables are represented and its scope?

728


What is lock escalation? : sql server database administration

820


What is a trigger and types of a trigger?

763