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: 3947 | Points: 40
Select from following answers:
  1. Yes
  2. No
  3. Maybe
  4. All Above

Show Correct Answer


| Alert Moderator 

Comments or Responses

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

Login to post response