Search
 
SCRIPT & CODE EXAMPLE
 

SQL

how to select first row of database sql

-- select the first row of database table
select * from company limit 1

----For DB2 

SELECT * FROM table_name FETCH FIRST 20 ROWS ONLY
Comment

PREVIOUS NEXT
Code Example
Sql :: update value postgresql 
Sql :: sql first character 
Sql :: get server date mysql 
Sql :: oracle trigger after connect 
Sql :: spring datasource properties mysql 
Sql :: how to check if a row is null in sql 
Sql :: copy postgres table from one schema into another 
Sql :: regex mongoose 
Sql :: CONCAT_WS() concat function in mysql 
Sql :: create or replace table sql 
Sql :: copy table in mysql with data 
Sql :: update using case in mysql 
Sql :: oracle insert into 
Sql :: sql cheat sheet pdf 
Sql :: postgresql create query 
Sql :: how to use rank function in sql 
Sql :: create a view in sqlite 
Sql :: How to convert DateTime to VarChar SQL 
Sql :: how to change a collumn name in sql 
Sql :: oracle show procedures 
Sql :: mysqldump ignore table 
Sql :: sequelize migration default value 
Sql :: how to transfer pandas datafra,e to sqlite 
Sql :: sql current date 
Sql :: how to generate a unique random number in mysql 
Sql :: 1396(hy00) mysql error 
Sql :: codigo crear tablas sql server 
Sql :: sqlite save db 
Sql :: mysql select date range last 30 days 
Sql :: return result of function in postgresql 
ADD CONTENT
Topic
Content
Source link
Name
2+5 =