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
Answers were Sorted based on User's Feedback
Answer / shyamsri83
The Maximum column value will be the output.
10
Is This Answer Correct ? | 30 Yes | 0 No |
Answer / sudhakar
10 because
its return max value of that column. interviewer wants to
check you r confidance so thats he confused you .
Is This Answer Correct ? | 5 Yes | 0 No |
how to generate XML out of QUERY?
How can a user-defined datatype be created?
What does man by sql wildcard characters in sql server?
what is the maximum size of a row? : Sql server database administration
What is mssql?
How to replace null values in expressions using isnull()?
How to list all columns in a table using odbc_columns()?
List some of the rules that apply to creating and using a ‘view’
How many types of Outer Joins?What are they?
Explain full-text indexing?
What is forward - only cursors / read only cursor?
What is a domain constraint give an example?