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
19392 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 the main differences between primary key and unique key?

993

What are the different stages in 'data warehousing'?

988

What is the difference between a catalog and a database?

929

Are databases stored on servers?

1040

What are different partitioning techniques in database?

903

Which parameters are optional in init.ora parameter file?

2214

What is the use of drop command and what are the differences between drop, truncate and delete commands?

1101

Tell me about view, sequence and index in DBMS.

1125

Enlist the cursor types.

1045

What is a key field?

991

What do you know about Master Data & Transaction Info Package?

997

What is sql in database management system?

949

What is a file in a database?

860

What are the three levels of data abstraction?

1103

Define primary and unique key?

1113