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 difference between paging and fragmentation?
What is structure of dbms?
what are database files, control files and log files. How many of these files should a database have at least? Why?
What are ACID properties?
11 Answers Amazon, Cap Gemini,
What are the 4 types of database?
What is Archived Redo Log ?
What are the four objectives of the selection of a data type?
In which phase of mload can I use .filler?
What is sorting in dbms?
Describe the Process of Feature Engineering using SQL.
Explain what are the two types of oltp?
What are the benefits of database?
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)