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
19536 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 is indexing in database with example?

1024

What is the purpose of queries in a database?

1110

Define a relation schema and a relation.

1162

What is implicit cursor in dbms?

1069

What database does facebook use?

1020

What is write ahead logging in DBMS?

1142

What are the benefits of database management system?

1089

What is the purpose of a model?

1061

What is the e-r model?

929

What are different types of transaction isolation levels?

1067

Enlist the various relationships of database.

1092

For each user who needs access, the DBA creates an account in which database?

1302

Mention the differences between unique key and primary key

1035

What is the difference between horizontal and vertical partitioning?

1044

What are the database objects?

1127