Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

4 Please write a querry to find repeated numbers in the
following table.
Table Name: Table1
Field1
10
15
20
15
10

Answer Posted / anjali

select count (distinct columnname)
from tablename

Is This Answer Correct ?    1 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you create type- insensitive operator?

1104


What is data compression? : sql server database administration

1018


What the class forname () does?

1142


What are the two authentication modes in sql server?

1171


What is a functions and types in sql server?

1150


What is the difference between a stored procedure and a user defined function?

1067


Explain about nested stored procedure?

1084


How do you create a data source?

962


Explain few examples of stored procedure over triggers?

1118


What are parameterized reports? What are cascading parameters in ssrs reports?

165


What is the difference between writing data to mirrored drives versus raid5 drives

990


what is the maximum size of a row? : Sql server database administration

1082


How to create new table with "create table" statements?

1195


What is difference between global temporary tables and local temporary tables?

1282


you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration

1030