Interested to Buy Any Domain ? << Click Here >> for more details...
I have Two table First have UserName and second is address,
in address table more than value relegated to UserName
table, i want to fetch 2nd address if exist other wise 1st
address access
- 4 Answers
- 6054 Views
- I also Faced
- E-Mail Answers
Answer Posted / sayali
Select u.name,coalesce(a.address2, a.address1)as Address
from Username u left join address a
on u.userid = a.userid
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what type of index will get created after executing the above statement? : Sql server database administration
What is truncate table?
Which is the main third-party tool used in sql server?
How many types of dimensions are there and what are they? : sql server analysis services, ssas
What is mapping schema?
What is sql sandbox in sql server?
What is the fastest way to permanently delete a 1 million row table named customers?
List the different types of joins?
What is a trace frag? Where do we use it?
Differentiate between a local and a global temporary table?
What is create command?
What is log in sql server?
What is molap and its advantage? : sql server analysis services, ssas
SQL Server Architecture ?
What is the use of group by clause?
