Database SQL / Scripts for '#Query'

Database SQL / Scripts for '#Query' - 3 Query/Script(s) found

Sample 1. Join Tables

select * from TABLE1 join TABLE2 on COLUMN_TABLE1 = COLUMN_TABLE2 where OTHER_COLUMN_TABLE1 is not null

_{Like Feedback join tables sql query}

Sample 2. Get count of Employees having salary greater than 1000

Select count(*) from EMPLOYEE e where e.salary > 1000

_{Like Feedback count count of employees having salary greater than select query sql}

Sample 3. Get all records having date since a particular date

select * from EMPLOYEE where JOINING_DATE between to_date('01-MAY-14', 'DD-MON-YY') and SYSDATE

_{Like Feedback select query to_date sysdate get records between 2 dates get records for last 2 years}

Search Database SQL / Scripts