A

@AdnanTurjoy

fetch only odd row from table

SQL
4 years ago
CREATE TABLE empDetails ( empId INTEGER PRIMARY KEY, name TEXT NOT NULL, managerID INTEGER NOT null, gender TEXT NOT NULL ); -- create a table empSalary create table empSalary ( empId INTEGER PRIMARY KEY, project TEXT not NULL,

remove duplicates from a table

SQL
4 years ago
-- create a table empDetails CREATE TABLE empDetails ( empId INTEGER PRIMARY KEY, name TEXT NOT NULL, managerID INTEGER NOT null, gender TEXT NOT NULL ); -- create a table empSalary create table empSalary ( empId INTEGER PRIMARY KEY,

fetch duplicate records from table

SQL
4 years ago
-- create a table empDetails CREATE TABLE empDetails ( empId INTEGER PRIMARY KEY, name TEXT NOT NULL, managerID INTEGER NOT null, gender TEXT NOT NULL ); -- create a table empSalary create table empSalary ( empId INTEGER PRIMARY KEY,

subquery group byorder by like

SQL
4 years ago
-- create a table empDetails CREATE TABLE empDetails ( empId INTEGER PRIMARY KEY, name TEXT NOT NULL, managerID INTEGER NOT null, gender TEXT NOT NULL ); -- create a table empSalary create table empSalary ( empId INTEGER PRIMARY KEY,

subquery

SQL
4 years ago
-- create a table empDetails CREATE TABLE empDetails ( empId INTEGER PRIMARY KEY, name TEXT NOT NULL, managerID INTEGER NOT null, gender TEXT NOT NULL ); -- create a table empSalary create table empSalary ( empId INTEGER PRIMARY KEY,

subquery

SQL
4 years ago
-- create a table empDetails CREATE TABLE empDetails ( empId INTEGER PRIMARY KEY, name TEXT NOT NULL, managerID INTEGER NOT null, gender TEXT NOT NULL ); -- create a table empSalary create table empSalary ( empId INTEGER PRIMARY KEY,

subquery

SQL
4 years ago
-- create a table empDetails CREATE TABLE empDetails ( empId INTEGER PRIMARY KEY, name TEXT NOT NULL, managerID INTEGER NOT null, gender TEXT NOT NULL ); -- create a table empSalary create table empSalary ( empId INTEGER PRIMARY KEY,