Latest Answer: Inner joins return rows from both joined tables where the join keys are equal. Outer joins return all rows from the "outer" table (which can be on the right or left side of the join) and only those rows from the other join table where the keys are equal. ...
Latest Answer: one can't rollback the operations which has commited. ...
Latest Answer: This is the solution if you want the sql to run in SQL Server 2005 :--------------------------------------------------------------select * from employee where sal in(select distinct top 5 sal from employee order by sal desc)order by sal desc---------------------------------------------------------------Hope ...
Latest Answer: in "union" only distinct values will be selected but in "union all "values will be selected irrespective of its frequency. ...
