1. Anonymous

    Sir please elaborate little bit
    I am unable to understand this

    select Ename,Basic_Sal from Employee
    where 2=(select COUNT(*) from Employee E where E.Basic_Sal >Employee.Basic_Sal)

  2. Anonymous

    Sir understood this by executing the following query

    select * from Employee E, Employee where E.Basic_Sal >Employee.Basic_Sal


  3. Hello friend.Sorry for delayed response.It really good to know that you understood the query.I just want to let you know that I am not a full time blogger but I am quite regular on blogger.Please be informed whenever you ask any query ,please wait until weekends.one more thing,please mention your name as well.thanks for reading my blog…


Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>