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
How to replace given values with null using nullif()?
How do you send email on SQL Server?
What are data resources?
How to use union to merge outputs from two queries together in ms sql server?
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
What are views used for?
What is use of dbcc commands?
What is transaction server consistency?
explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
How do database indexes work?
Can foreign key be deleted?
What is the difference between the 2 operating modes of database mirroring?
How to filter out duplications in the returning rows in ms sql server?
What is intellisense?
What is the difference between function and stored procedure in sql server?