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 |
Please get the 4 th maximum salary from a table without using any sql keyword (TOP,MAX are mot allowed)
What is the purpose of the model database?
Do you know what is openxml in sql server?
Can you pass expressions to stored procedure parameters?
when would you go for denormalization? : Sql server database administration
Explain about system stored procedure?
What are the different types of indexes?
HOW TO RENAME A COLUMN NAME
What is Schema? and why we use schemas?
What guidelines should be followed to help minimize deadlocks?
Write a SQL queries on Self Join and Inner Join.
What is a SQL Server Temporary Table?