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 / 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 |
Post New Answer View All Answers
What purpose does the model database server?
Can we use having clause without group by?
How many databases can we create in a single server?
can any body tell me how to know the password of current user in sql server
What are .mdf files?
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
What is a self join in sql server?
Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?
Tell me can we use custom code in ssrs?
What is the contrast between sql and pl/sql?
How to change the name of a database user?
What is collation?
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
How to connect to SQL Azure Database by using sqlcmd?
What is attribute? : sql server analysis services, ssas