Search
 
SCRIPT & CODE EXAMPLE
 

SQL

get top 10 records in oracle

Oracle:
SELECT * FROM Customers
FETCH FIRST 10 ROWS ONLY;

MySQL:
SELECT * FROM Customers
LIMIT 10;

SQL Server/MS Access: 
SELECT TOP 3 * FROM Customers;
Comment
PREVIOUS NEXT
Code Example
Sql :: mysql grant grant option 
Sql :: date formats in sql server 
Sql :: SQL date part only of datetime 
Sql :: how to delete a record from sqlite in android 
Sql :: delete record mysql query 
Sql :: wordpress delete post revisions older than date "sql" 
Sql :: psql connect as user with password 
Sql :: get date ISO in psql 
Sql :: check if sql temp table exists 
Sql :: mysql inner join 3 tables 
Sql :: find duplicate users by email address in mysql 
Sql :: postgres add column integer 
Sql :: update value postgresql 
Sql :: update column data type postgres 
Sql :: copy postgres table from one schema into another 
Sql :: create pl/sql stored procedure 
Sql :: sqlite woth cmake 
Sql :: update using case in mysql 
Sql :: oracle convert int to date 
Sql :: sql delete row with auto increment 
Sql :: sql compare two tables for differences 
Sql :: mysql case when or 
Sql :: begin transaction sql 
Sql :: sql server output parameter 
Sql :: mysqldump ignore table 
Sql :: SQL Auto Increment Primary Key - PostgreSQL 
Sql :: postgre sql create table 
Sql :: how to query without duplicate rows in sql 
Sql :: connect mysql command line 
Sql :: sql #region 
ADD CONTENT
Topic
Content
Source link
Name
3+2 =