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
- 5486 Views
- I also Faced
- E-Mail Answers
Answer Posted / vardhan rao
select ucase(mid(Fname,1,1)) as
FirstName,ucase(mid(Lname,1,1)) as
LastName,ucase(mid(City,1,3)) as Cty,ucase(mid(Pin,-3))as
PinCode from empadd
Output:
FirstName LastName City Pincode
R K SAL 241
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
List the different types of normalization?
What is the difference between MyISAM Static and MyISAM Dynamic?
How to create a table index in mysql?
How do I install mysql?
What's new in mysql 8?
How do I create a schema in mysql?
What are mysql queries?
What is RMS Migrations
What is a select query?
How do I run mysql on a mac?
List data types in mysql? Explain
How to dump a table from a database.
How do you determine the location of mysql data directory?
How can you export the table as an xml file in mysql?
What are the benefits of mysql?
