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 database implementation?
Can you drop all the columns of a table ?
What restrictions can you apply when you are creating views?
What are the three levels of data abstraction?
What are the key constraints in dbms?
How to create a database from my program?
What is a system concept?
What is progress actional?
Define view, sequence and index in DBMS.
From where ENQUEUE resources parameter information is derived ?
What is normalisation and its type?
What is buffer manager?
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)