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 |
what is index seek and index scan?
What is built-in function?
What are the types of constraints?
What are database states in ms sql server?
What is the difference Between Sql-server 2000 & 2005
How do you implement session management in SQL Server mode?
After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas
What is BCNF? How is it better than 2NF & 3NF?
Explain sp_configure commands, set commands?
Explain a checkpoint?
What happens if null values are involved in datetime operations?
What are out-of-range errors with date and time literals?