• Home
  • Interview Questions
  • Online Quiz Tests
  • Blog
  • Contact Us

Global Guideline - Interviewer and Interviewee Guide

Links
  • Home
  • Interview Questions
  • Online Quiz Tests
  • Blog
  • Contact Us
  1. Interviews
  2. DB Programming
  3. DB Development

DB Development Question:

How to find the duplicate rows count from employees table in oracle?

DB Development Interview Question
DB Development Interview Question

Answer:

select employee_id, count(*) from employees group by
employee_id having count(*) > 1


Previous QuestionNext Question
What is the family trees and connection by clause?In which phase of mload can i use .FILLER?

Interview Categories:

    • Btrieve
    • Clipper
    • Data Modeling
    • Data Structures
    • Database Administrator (DBA)
    • Database Analyst
    • Database Developer
    • Database Hierarchical
    • Database Network
    • DB Development
    • EDI/Data Integration Expert
    • Firebird
    • IBM DB2
    • Informix
    • Java Database
    • MariaDB
    • Microsoft Access Developer
    • MongoDB
    • MS SQL Server
    • MySQL Programming
    • NoSQL
    • Object Relational
    • Postgre
    • PostgreSQL
    • Progress
    • RDBMS
    • Relational Database
    • SQL
    • SQL Administrator
    • SQL and PL/SQL
    • SQL Notification Services
    • SQL server 2008
    • SSRS
    • Stored Procedure
    • Sybase
    • Teradata

Most Popular Quiz Categories:

Java AWT And SwingHTMLSQLOOAD (Object Oriented Analysis and Design)SAT (Scholastic Aptitude Test) Sentence CorrectionBiology Aptitude TestStatistics Aptitude TestNetworkingChemistry Aptitude TestManagement

Most Popular Interviews

  • Business and Economy
  • Networking
  • Computer Programming
  • Operating System
  • Computer Hardware

Most Popular Quizzes

  • Information Technology
  • Networking
  • Engineering
  • Accounting
  • Java

Keep in touch with us

 

Copyright © 2007 - globalguideline.com

all rights reserved.
  • About Us
  • Contact Us
  • Blog
  • Terms of use
  • Privacy Policy