Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3 Answers
- 5020 Views
- I also Faced
- E-Mail Answers
Answer Posted / monal
TRY THIS:
SELECT FIRSTNAME +'-'+LASTNAME FROM 'TABLENAME'
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
Does an index slow down updates on indexed columns?
What’s the use of custom fields in report?
What are the advantages of paper records?
Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication
What are the properties of sub-query?
Tell me the difference between clustered and non-clustered index?
What to perform pattern match with the like operator?
What is extent? Types of extents?
How optimize sql query with multiple joins in sql server?
When would you use the stored procedures or functions?
How do we know if any query is retrieving a large amount of data or very little data?
How to create an multi-statement table-valued function?
What is abstracting periodical?
what is difference between view and Dip.
What happens when converting big values to numeric data types?
