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 / vikas

select top 100 max(field name) from Table Name

Is This Answer Correct ?    12 Yes 17 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What happens if null values are involved in boolean operations?

1041


Can we call future method from queueable?

1097


hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

2984


How to connect of datebase with sql express.?

1143


What is difference between getdate and sysdatetime in sql server 2008?

1097


List some advantages and disadvantages of stored procedure?

1063


What does it mean to be in union?

979


How you can get the list of largest tables in a database?

1062


How to bind a view to the schema of the underlying tables?

1046


What is transaction server consistency?

1104


What is the return type of executeupdate ()?

950


Explain the difference between delete,drop and truncate in SQL Server?

1159


What is a performance monitor?

1020


Is mysql better than sql server?

1106


What is a cache in ssrs?

138