KnowledgeForum

Earn knowledge and go ahead in life

Monday, 23 July 2012

displaying only duplicate rows in oracle

select id,name,salary  from employee
group by(id) having count(*) >=2;
Posted by Knowledge Forum at 10:23
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2016 (6)
    • ►  October (5)
    • ►  March (1)
  • ►  2013 (5)
    • ►  December (5)
  • ▼  2012 (20)
    • ▼  July (20)
      • top 10 engineering colleges in bangalore
      • displaying only duplicate rows in oracle
      • DB import, export and DB load commands in Informix
      • Escape seqence in oracle queries
      • joining tables from different database in informix
      • latest news on technology
      • difference between count(*), count(age) and count(...
      • case in PL/SQl
      • dbschema of table in oracle
      • transaction recovery in Oracle
      • Informix database architecture
      • Important linux commands
      • dbschema of database in informix
      • UPSC exams
      • KPSC exams
      • VTU results
      • Civil Technical seminar PPT'S free download
      • Informix database
      • CS Technical seminar PPT'S free download
      • Database transaction management.

About Me

My photo
Knowledge Forum
I am passionate about Blogging
View my complete profile
Picture Window theme. Powered by Blogger.