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

Answer Posted / krishan

Please solve my problem?

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain system rowset functions?

654


what is a default tcp/ip socket assigned for sql server? : Sql server database administration

647


What is ssrs?

101


What is Replication?

720


How many primary keys are possible in a table?

599






What are scheduled tasks in sql server?

648


what is the Ticketing tool used in Wipro technologies at Bangalore...???

7611


tell me what is blocking and how would you troubleshoot it? : Sql server database administration

566


Why should one not prefix user stored procedures with ‘sp_’?

695


Can group functions be used in the order by clause in ms sql server?

680


How to store and query spatial data?

641


how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration

650


Using the customer, and order table in northwind database, please write a query to produce xml?

757


What is the full form of dql?

614


What is dml command?

621