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 |
Indexes are updated automatically is the full-text index also updated automatically?
What is raiseerror? What is raiseerror?
How to rename an existing table with the "sp_rename" stored procedure in ms sql server?
What is logon trigger?
Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?
Write an sql query to find first weekday of the month?
How to delete an existing row with delete statements in ms sql server?
Describe how to use linked server?
How can you swap values between two rows in a table using single- SQL statement?
1 Answers Tavant Technologies, Virtusa,
What does indexation mean?
How to enter binary string literals in ms sql server?
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
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)