Interested to Buy Any Domain ? << Click Here >> for more details...
Fname Lname City Pin
ramesh kumar salem 365241
Query to generate a code having the firstletter of
Fname,Lname & 3letter of city Last 3letter of pin,all in
capital letters
- 3 Answers
- 5387 Views
- I also Faced
- E-Mail Answers
Answer Posted / sonali
select substr(ucase(Fname),1,1), substr(ucase(Lname),1,1),
substr(ucase(City),1,3), mid(Pin,-3) from emp
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do I check mysql version?
What is 'mysqldump'?
What is mysqli_free_result?
What is a join? Explain the different types of mysql joins.
How to execute mysql query in php?
How do I run mysql?
What is mysql server used for?
How much does mysql enterprise cost?
all the queries used in sql
How can we get the number of rows affected by query?
Where is mysql data stored linux?
How to show table structure mysql?
Why mysql is open source?
What are date and time data types?
Where MyISAM table will be stored and also give their formats of storage?
