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

The output is 10

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to provide values to user defined function parameters?

568


What is the purpose of the tempdb database?

585


Difference between connected and disconnected database in .net with sql server?

587


What is 1nf 2nf and 3nf?

501


What is the difference between TRUNCATE and DROP?

635






What is the purpose of optimization?

554


How to drop an existing stored procedure in ms sql server?

554


How to use “drop” keyword in sql server and give an example?

692


What are the differences between having and where clause.

566


What is difference between Datepart() and Datename() in SqlServer?

732


Tell me about the approaches which you used to counter the DI problems.

771


What is a transact-sql statement?

545


How to rename databases in ms sql server?

633


What are truncate options available in sql server? : sql server database administration

589


How many clustered indexes there can be on table ?

613