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 |
What is clustered primary key?
How do I compare two values when one value(data type) is char and the other is an integer?
What does Master database contains?
how would you troubleshoot blocking? : Sql server database administration
What is a primary index?
How do you persist objects, permissions in tempdb
1.How to check the backup file details if we do not have access to that folder 2.how to check the backup file size without connecting to the folder
3 Answers CarrizalSoft Technologies, IBM,
How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?
What are the options which must be set to allow the usage of optimistic models?
What is the difference between dropping a database and taking a database offline?
what is a traditional network library for sql servers? : Sql server database administration
What is use of except clause? How does it differ from not in clause?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)