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 |
Is mysql better than sql server?
What are the types of backup and tell me the difference between full and differential backup?
How important do you consider cursors or while loops for a transactional database?
What is difference between index and primary key?
How To Make password Protected SQL Server 2005 Database i.e when i open SQL Server database then ask for password.
What is a deadlock and what is a live lock?
What is the difference between varchar and varchar types?
How to restore performance issues and how to check?
Do you know how to implement service broker?
What is split brain scenario in DB mirroring?
ehat is the default port no of sql 2000?
What is the joins and how many types of Joins in sql server a diffrentiate ever one give a suaitable query
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)