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 are the different types of replication? How are they used?
What is self contained sub query?
Explain the storage models of OLAP?
Equi join and non equi join is possible with sql server?
Explain what are commit and rollback in sql?
What is the contrast amongst drop and truncate?
How to view existing indexes on an given table using sp_help?
What is a database in ms sql server?
Explain about temporary stored procedure?
What is the fastest way to permanently delete a 1 million row table named customers?
What is de-normalization in sql database administration? Give examples?
What is pessimistic concurrency?
Oracle (3253)
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)