mysql> select substring('SQUARE ANS ALWAYS WORK HARD',14,6);

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

Question Posted / abhishek

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

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 are stored procedures in a database?

958

Explain the term specialization.

863

What is foreign key in dbms?

892

What is the purpose of database management system?

1054

What is the role of database server in database management system?

884

Can we use GO_BLOCK package in a PRE_TEXT_ITEM trigger ?

2946

How to move a multi-file database?

1044

Define weak entity set.

1081

Mention the differences between union and union all

927

What's the difference between star and snow flake schema?

1051

What are the characteristics of dbms?

900

What is tuple in dbms?

883

What is database normalization with example?

943

What are the limitations of rdbms?

967

Which is fastest database?

911