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
19323 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

Is sql a rdbms?

794

Explain 2nf?

937

What is the normal procedure followed by a java client to access the db?

808

What are the types of database explain each of them briefly?

930

What is the purpose of a database middleware other than translating the jdbc api calls to multiple vendor specific dbms calls?

813

Give us a non-computer example of preemptive and non-preemptive scheduling?

905

What happens when my integer identity runs out of scope?

951

Mention the different types of cursor?

966

Who proposed the relational model?

949

What is a data type in a database?

1002

What is a Federated Query ?

987

What do you mean by starvation in dbms?

1180

Describe concurrency control.

1030

What are the 5 databases?

831

What is cold backup and hot backup (in case of oracle)?

890