what the SUBSTR(SQUARE ANS ALWAYS WORK HARD,14,6) will return ?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is oracle block? Can two oracle blocks have the same address?

592


What is a data source (ds)?

486


What is a database management system and give examples?

443


What does fill factor concept mean with respect to indexes?

475


Why is maintaining a database important?

446






What are the different types of database?

474


What do you understand by functional dependency and transitive dependency in dbms?

459


What do you understand by functional dependency?

492


How many types of users in dbms?

419


Differentiate between nested loop, hash loop and merge join.

460


How do I keep my database up to date?

487


How to repair a corrupt firebird database?

514


What do you mean by deadlock dbms?

513


What is dba stand for?

462


Explain the terms specialization and generalization.

501