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


Please Help Members By Posting Answers For Below Questions

What is auditing in sql server?

501


What are orphan records?

545


What is log shipping?

559


You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?

99


What is the Control Flow in SSIS

572






Why do we need normalization?

488


Why Master database is required?

598


What are commonly used odbc functions in php?

536


How to modify an existing stored procedure in ms sql server?

527


What are the purposes of floor and sign functions?

538


What is after dml trigger?

571


How to execute stored procedure in select statement sql server?

529


What are different types of statements that are supported by sql?

593


What is table valued function and scalar valued functions?

489


What is the difference between a fill factor of 100 and 0?

528