you are provided with the single table having say 4 col ie
fname lname age city , now the all records with displying of
only fname and lname is required but in this format say my
name is abhay khanna it will come like this
abhay-khanna
rahul-roy
gaurav-singh
the above format is required
Answer Posted / monal
TRY THIS:
SELECT FIRSTNAME +'-'+LASTNAME FROM 'TABLENAME'
Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
How to round a numeric value to a specific precision?
How do I connect to sql server database?
What is difference between standardization and normalization?
Do you know the capabilities of cursors?
What is scheduled job and how to create it?
What is the template in sql?
How we can compare two database data?
How to send email from database?
What are the different types of Indexes available in SQL Server?
What is difference between sql and sql server?
What is the purpose of the model database?
What is difference between inner join and join?
What new data source types were added in ssrs 2014?
Do you know what are the steps to process a single select statement?
What program is used to store the data source file?