how do you count the duplicate records in a table
- 10 Answers
- 17340 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / akki julak
select count(empno)-count(distinct(empno)) from emp;
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Write a sql query to get the third highest salary of an employee from employee_table?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
What is data control language?
What is informix sql?
What is the process of debugging?
what are all types of user defined functions? : Sql dba
How is a PL/SQL code compiled?
What is the benefit of foreign key?
How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000
Is sql injection illegal?
Does pl/sql support create command?
Does postgresql run on the cloud?
How do I run sql profiler?
Mention what are the benefits of pl/sql packages?
How do rank () and dense_rank () differ?
