Search Database SQL / Scripts

  Help us in improving the repository. Add new Queries/Scripts through 'Submit Database SQL / Scripts ' link.

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

Subscribe to Java News and Posts. Get latest updates and posts on Java from
Enter your email address:
Delivered by FeedBurner