In the following SQL
Code: Select all
SELECT A.bonus, emp_name from (SELECT DISTINCT BONUS FROM EMP) A
where some condition
Code: Select all
SELECT A.bonus, emp_name from (SELECT DISTINCT BONUS FROM EMP) A
where some condition
You need to be a member in order to post a reply
Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute