Are the two statements same :-

select custid from tbl_order;

select All custid from tbl_order;

Posted by Akiii on 5/31/2012 | Category: Sql Server Interview questions | Views: 5389 | Points: 40

Select from following answers:

Show Correct Answer

| Alert Moderator

Bookmark It

< Previous : In WCF, can data contract classes inherit from one ...

Next > : There are two tables, customer table has 5 rows an ...

Posted by: Ras90it on: 6/1/2012 | Points: 10

How to show only Duplicate values ???

Posted by: Akiii on: 6/1/2012 | Points: 10

Try this @Ras90it

SELECT     tablefield, COUNT(tablefield) AS dup_count 

FROM         table

GROUP BY tablefield

HAVING     (COUNT(tablefield) > 1)

Regards
Akiii

Posted by: Ras90it on: 6/1/2012 | Points: 10

Thank you

Posted by: Akiii on: 6/1/2012 | Points: 10

Its okay @Ras90it...

Thanks and Regards
Akiii

More Interview Questions by Akiii

Latest Interview Questions