Interview Questions
Search
Legacy
Tests
Repository
DashBoard
Java
Java 8
Java 7
Java Abbreviations
OCJP / SCJP
Class List
New in Java 8
Java Exceptions
Spring Exceptions
Java Enums
Java 8 Lambda
Java 8 java.time
Big Data
Discussion Forum
Humor
Classes Search
Subscribe
Search Database SQL / Scripts
Help us in improving the repository. Add new Queries/Scripts through 'Submit Database SQL / Scripts ' link.
Search
Submit SQL/Scripts
Database SQL / Scripts for '#Display pairs of Department Names where first dept name has lesser employees than later' - 1 Query/Script(s) found
Sample 1. Display pairs of Department Names where first dept name has lesser employees than later
Select D1.name , D2.name from Dept D1, Dept D2 where D1.employee_count < D2.employee_count
Like
Feedback
Display pairs of Department Names where first dept name has lesser employees than later
self join
select statement
example of self join
Correction
Suggestion
Subscribe to Java News and Posts. Get latest updates and posts on Java from Buggybread.com
Enter your email address:
Delivered by
FeedBurner