SELECT * from Table2 EXCEPT SELECT * FROM Table1

hi,

how to match retrieve the unmatched records from 2 tables
in which we dont have any primary key. example : table1 has
1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want
the numbers from 6 to 10 to be displayed and should not
come as null. i need the numbers. please reply as soon as
possible.

Question Posted / newbie

4 Answers
8382 Views
I also Faced
E-Mail Answers

Answer Posted / newbie

SELECT * from Table2
EXCEPT
SELECT * FROM Table1

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to delete existing triggers using "drop trigger"?

1097

List few advantages of stored procedure.

1026

What are the types of resultset?

1012

what is a join? : Sql server database administration

1323

What is difference between temp table and cte?

1071

How to assign null values to variables or columns?

1026

How to connect to a sql server using odbc_connect()?

1202

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

2007

Describe how to use linked server?

1076

What is isnull() operator?

1090

Describe different Processing Modes offered by SSRS?

256

What is explicit mode in sql server?

1109

What is the difference between char and varchar2 datatype in sql?

1117

List the various tools available for performance tuning?

923

What kind of problems occurs if we do not implement proper locking strategy?

1460