what the SUBSTR(SQUARE ANS ALWAYS WORK HARD,14,6) will return ?
Answers were Sorted based on User's Feedback
Answer / cijo
ERROR!!!!
But SUBSTR('SQUARE ANS ALWAYS WORK HARD',14,6) will return
WAYS W
| Is This Answer Correct ? | 60 Yes | 15 No |
Answer / abhishek
mysql> select substring('SQUARE ANS ALWAYS WORK HARD',14,6);
+-----------------------------------------------+
| substring('SQUARE ANS ALWAYS WORK HARD',14,6) |
+-----------------------------------------------+
| WAYS W |
+-----------------------------------------------+
1 row in set (0.00 sec)
mysql>
| Is This Answer Correct ? | 6 Yes | 4 No |
What is data model in database?
What is cardinality in db?
What is Archived Redo Log ?
What is snow flake schema design in database? What's the difference between star and snow flake schema?
What is meant by database server?
What is the purpose of normalisation?
What is an extensible database?
Is database a data structure?
What is Distributed database ?
What are data modelling tools?
write a query to Find the Maximun second value in table?
what is dba_segment
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)