Interview questions

SQL Server - What do you mean by TABLESAMPLE?

Next>>         SQL Server tutorial  

SQL Server - What do you mean by Table Sample? - Feb 27, 2010 at 11:50 AM by Shuchi Gauri

What do you mean by Table Sample?

TABLESAMPLE allows users to get a sample of set of data from a table without performing a complete table scan. Data is read at a page level.


Select * from tablename TABLESAMPLE (20 PERCENT/ROWS)

SQL Server - What do you mean by Table Sample? - May 05, 2009 at 22:00 PM by Rajmeet Ghai

What do you mean by Table Sample?

TABLESAMPLE is a clause that can be used in a FROM clause query to limit the number of rows retuned from a result set. This limitation can be specified by mentioning the “percentage” of rows to be returned.


Select name, salary FROM employee TABLESAMPLE(10 PERCENT);

An approximate of 10% of rows is returned.


Also read

Define Normalization and De- Normalization.

Answer - It is the process of organizing data into related table. To normalize database, we divide database into tables.....

Define database objects.

Answer - SQL Server database stores information in a two dimensional objects of rows and columns called table......

Describe in brief exporting and importing utility?

Answer - The Bulk Copy is a command utility that transfer SQL data to or from a data file. This utility mostly used to transfer huge data to SQL server from other database....

Write your comment - Share Knowledge and Experience


Latest placement tests
Latest links
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring