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 attribute hierarchy? : sql server analysis services, ssas
Where can you add custom error messages to sql server?
How to create a new schema in a database?
How to transfer a table from one schema to another?
What is Dependency Injection and provide example?
What are the benefits of using stored procedures over sql statements?
what is a check constraint?
Where is localdb stored?
What are dml (data manipulation language) statements in ms sql server?
What happens if null values are involved in comparison operations?
How many types of Cursor in SQL SERVER?
What is sql language?
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)