Interested to Buy Any Domain ? << Click Here >> for more details...
check whether all the emp numbers are indeed unique.
- 6 Answers
- 17854 Views
- I also Faced
- E-Mail Answers
Answer Posted / nagendra
select empno, count(empno)
from emp
group by empno
having count(empno) > 1;
| Is This Answer Correct ? | 22 Yes | 4 No |
Post New Answer View All Answers
Define a temp table?
How do you use a while loop in pl sql?
How to get list of all tables from a database?
What is sqlite used for?
How do I know if I have sql express or standard?
Is primary key a clustered index?
How do you go back in sql?
How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?
How can we link a sql database to an existing android app?
Write the command to remove all players named sachin from the players table.
What is the difference between an inner and outer join?
What is the difference between Union and Union all. Which is faster.
What is the cause of mutating table error and how can we solve it?
Why triggers are used?
What is sql basics?
