Search
 
SCRIPT & CODE EXAMPLE
 

SQL

if then else sqlite

SELECT *,
       CASE WHEN Password IS NOT NULL
       THEN 'Yes'
       ELSE 'No'
       END AS PasswordPresent
FROM myTable
Comment

PREVIOUS NEXT
Code Example
Sql :: FIND OUT THE NAME HIGHEST SALARY SQL 
Sql :: set auto increment to 1 mysql 
Sql :: drop table if exists 
Sql :: set auto increment from 1 
Sql :: create sqlite database in laravel 
Sql :: get last record in sql 
Sql :: ksql terminate all queries 
Sql :: postgres format date in select 
Sql :: select first rows postgresql 
Sql :: alter table add column 
Sql :: PL SQL MODIFY COLUMN NME 
Sql :: sql to char 
Sql :: select count of distinct values sql 
Sql :: oracle list user grants 
Sql :: SQLite order random 
Sql :: mysql safe mode 
Sql :: show processlist mysql full query 
Sql :: where clause for child record apex 
Sql :: create table with select 
Sql :: sysdate in oracle sql 
Sql :: sql create table if not exists 
Sql :: purge undo tablespace oracle 11g 
Sql :: sqlserver docker 
Sql :: postgres autoincrement primary key 
Sql :: sql rank 
Sql :: mysql grant grant option 
Sql :: ora-01109 database not open in oracle 19c 
Sql :: find duplicates mysql 
Sql :: oracle difference between two dates in seconds 
Sql :: How to Find Duplicate Values in a SQL Table 
ADD CONTENT
Topic
Content
Source link
Name
3+9 =