Self join to a table

Posted by Mohit on Stack Overflow See other posts from Stack Overflow or by Mohit
Published on 2010-06-14T05:29:17Z Indexed on 2010/06/14 5:32 UTC
Read the original article Hit count: 352

Filed under:

self-join

I have a table like

Employee
==================
name      salary
==================
a        10000
b        20000
c        5000
d        40000

i want to get all the employee whose salary is greater than A's salary. I don't want to use any nested or sub query. It has been asked in an interview and hint was to use self join. I really can't figure out how to achieve the same.

Related posts about self-join

SQLite self-join performance

as seen on Stack Overflow - Search for 'Stack Overflow'
What I essentially want, is to retreive all features and values of products which have a particular feature and value. For example: I want to know all available hard drive sizes of products that have an Intel processor. I have three tables: product_to_value (product_id, feature_id, value_id) features… >>> More
SQL Self Join Query Help

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi All, I'm trying to work out a query that self join itself on a table using the eventnumber. I've never done a self join before. What i'm trying to query is when a client has started off in a city which is chester to see what city they moved to. But I dont want to be able to see if they started… >>> More
Need some serious help with self join issue.

as seen on Stack Overflow - Search for 'Stack Overflow'
Well as you may know, you cannot index a view with a self join. Well actually even two joins of the same table, even if it's not technically a self join. A couple of guys from microsoft came up with a work around. But it's so complicated I don't understand it!!! The solution to the problem is here:… >>> More
Grails - Self Join

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, When I write the following class, I get the following compilation error: could not resolve property How can I achive the following: class Employee{ String Name String Email Employee Manager static hasMany = [desginations:Designation] static constraints = { Name(unique:true) … >>> More
replace selfjoin with analytic functions

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi Any ideas how i go about replacing the following self join using analytics SELECT t1.col1 col1, t1.col2 col2, SUM((extract(hour FROM (t1.times_stamp - t2.times_stamp)) * 3600 + extract(minute FROM ( t1.times_stamp - t2.times_stamp)) * 60 + extract(second FROM ( t1.times_stamp - t2.times_stamp))… >>> More

Developer IT

Self join to a table - Developer IT

Self join to a table

self-join

Related posts about self-join

SQLite self-join performance

SQL Self Join Query Help

Need some serious help with self join issue.

Grails - Self Join

replace selfjoin with analytic functions

Categories cloud