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...

How to get max 100 values from sql server

Answer Posted / ashis dey

select top 100 fieldname from tablename group by fieldname

Is This Answer Correct ?    0 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the ‘fillfactor’?

917


Define left outer join?

922


How many primary keys are possible in a table?

872


How can we rewrite sub-queries into simple select statements or with joins?

921


What is the exact numeric data type in sql?

960


Explain about nested stored procedure?

976


Explain syntax for disabling triggers?

971


What is database black box testing?

984


How to create stored procedures with parameters in ms sql server?

991


What is the difference between clustered and non-clustered indexes in ms sql server?

937


What are the advantages of sql stored procedure?

1015


What is the difference between an index and a unique index?

952


You want to implement the one-to-many relationship while designing tables. How would you do it?

911


What is sub query and its properties?

917


What is a group function explain with an example?

939