Select sample data in huge tables

Hello Readers,

Often we want to select some sample rows from a table to get some idea about data. Following are ways to achieve this in different databases:

1) Oracle

select * from customer where rownum<10;

2) MySQL

select * from customer limit 10;

3) SQL Server

select top 10 from customer;

Advertisements