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 |
Delete duplicate rows without using rowid.
What are the different types of lock modes in sql server 2000?
How to trouble shoot if unable to connect SQL Server
Explain SELF JOIN ?
What are user defined datatypes and when you should go for them?
What is the sql profiler?
Explain the benefits of user-defined functions?
Can primary key be null?
wat is the main diff between sql server 2000and sql server 2005
What is your recommendation for a query running very slow? : sql server database administration
What is user stored procedure & it purpose?
How many triggers are possible per table?