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

Question Posted / guest

3 Answers
18320 Views
Citrix, SAP Labs, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / cijo

ERROR!!!!

But SUBSTR('SQUARE ANS ALWAYS WORK HARD',14,6) will return

WAYS W

Is This Answer Correct ?

60 Yes

15 No

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

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 the SUBSTR(SQUARE ANS ALWAYS WORK HARD,14,6) will return ?..

Answer / guest

ALWAYS

Is This Answer Correct ?

15 Yes

21 No

Post New Answer

More Database Management Interview Questions

What is cluster table or non_cluster table?