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 does rdbms stand for?

813


How to change database dialect?

661


Is access a database program?

626


Have you written applications to retrieve stored images in a table?

760


What are the various Database states.

732






What is openedge abl in terms of taking the perspective of the developer?

655


What is super key in dbms?

636


Explain concurrency transparency.

770


How do you rename a database?

640


What is data model example?

645


Explain the different types of languages that are available in the dbms?

657


What is the concept of sub-query in terms of sql?

695


What is a database report?

670


What is the advantage of using preparedstatement?

652


What are the differences between a dbms and rdbms?

647