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 / bhagat

output will be 10.

Is This Answer Correct ?    14 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Distinguish between nested subquery and correlated subquery?

558


What are various ways to enhance the ssrs report?

544


What is the optimization being performed in oracle and SQL Server?

637


What are indexers?

639


What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

569






How to convert a unicode strings to non-unicode strings?

573


What is normalization? Describe its different types.

599


Do you know what are the reporting services components?

539


How global temporary tables are represented and its scope?

561


What is query processing?

549


Why we use trigger in sql server with example?

517


What is report snapshot in ssrs?

166


What is the maximum row of a size?

584


What are the differences between “row_number()”, “rank()” and “dense_rank()”?

547


How to use values from other tables in update statements in ms sql server?

567