select names from (select full_name as names from table 1) a union sele

How to swap the data of two columns in a table. both the
columns containing varchar values.

Question Posted / dinesh

Answer Posted / dinesh

select names from
(select full_name as names from table 1) a
union
select full_name as names from table 2

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How do you identify a foreign key?

988

What are the disadvantages of primary key and foreign key in SQL?

1071

How to list all user names in a database?

1023

What is acid properties?

1040

Do you know what is fill factor and pad index?

961

What is difference between commit and rollback when used in transactions?

926

Why truncate is ddl command?

1016

What is the importance of concurrency control?

1190

Where to find ntwdblib.dll version 2000.80.194.0?

937

What xml support does the sql server extend?

971

How to find out the list schema name and table name for the database?

906

When columns are added to existing tables, what do they initially contain?

997

How to modify existing triggers using "alter trigger"?

959

What is dknf in normalization form?

1002

What do you mean by data manipulation language?

964