rakib10rr3

dependencies {
    implementation fileTree(dir: 'libs', include: ['*.jar'])
    implementation "org.jetbrains.kotlin:kotlin-stdlib-jdk7:$kotlin_version"
    implementation 'androidx.appcompat:appcompat:1.1.0'
    implementation 'androidx.core:core-ktx:1.2.0'
    implementation 'androidx.constraintlayout:constraintlayout:1.1.3'
    implementation 'androidx.legacy:legacy-support-v4:1.0.0'
    testImplementation 'junit:junit:4.12'
    androidTestImplementation 'androidx.test.ext:junit:1.1.1'
    androidTestImplementation 'androidx.test.espresso:espresso-core:3.2.0'

rakib10rr3

#1.1 - You have a table and want to see all of the data in it.
SELECT * FROM EMP;

#1.2 - You have a table and want to see only rows that satisfy a specific condition.
SELECT * FROM EMP WHERE DEPTNO = 10;

#1.3 - You want to return rows that satisfy multiple conditions.
SELECT * FROM EMP WHERE DEPTNO = 10 OR COMM IS NOT NULL OR SAL <= 2000 AND DEPTNO = 20;
SELECT * FROM EMP WHERE (DEPTNO = 10 OR COMM IS NOT NULL OR SAL <= 2000) AND DEPTNO = 20;

rakib10rr3

#1.1 - You have a table and want to see all of the data in it.
SELECT * FROM EMP;

#1.2 - You have a table and want to see only rows that satisfy a specific condition.
SELECT * FROM EMP WHERE DEPTNO = 10;

#1.3 - You want to return rows that satisfy multiple conditions.
SELECT * FROM EMP WHERE DEPTNO = 10 OR COMM IS NOT NULL OR SAL <= 2000 AND DEPTNO = 20;
SELECT * FROM EMP WHERE (DEPTNO = 10 OR COMM IS NOT NULL OR SAL <= 2000) AND DEPTNO = 20;