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 |
Mention a query to calculate the even and odd records from a table
What is database management system(dbms) and why it is used?
What do you mean by transparent dbms?
What is the use of GRANT option in EXP command ?
Difference between data and information, and how are they related in a database?
Which parameters are optional in init.ora parameter file?
What is partial key?
What you know in mapping of erd to dfd?
What is the difference between a database and a spreadsheet?
How can you get the alternate records from the table in the sql?
Describe the purposes and advantages stored procedure?
What are databases what are the uses of databases?
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)