Ask the Community
Ask any professional question and get answers from other specialists.
I completed my graduation last year and i am getting started with SQL. can anyone help me to solve this query. Table name is Employee and it has the following fields EM ... See More
programming in c#+vb.net sqlserver
Expecting EMPNO is essential/primary key and ENAME has duplicate values then you can use following SQL. select ENAME from EMPLOYEE group by ENAME having count(ENAME) > ... See More
Sadly i can't yet understand your question!!! please clarify so i can may be help you.... are you talking about finding developers (c#,java, sql, ...) or finding any ... See More
Use Analytical Functions (My Answer is based on Oracle). For example if you have 4 records in your Employee as follows and you want to delete duplicate records. 1 Jhon ... See More
select EMPNO, ENAME, SAL, JOB, DEPTNO from employee group by EMPNO, ENAME, SAL, JOB, DEPTNO having count(*)>=2;
SELECT column_name FROM tablename GROUP BY column_name HAVING COUNT(column_name ) > 1
select distinct * from employee;
select column1, column2..., count(columnlast) from table_name where (all_conditions_if_required) group by columnlast ------ (if it is the comlumn with duplicate data) hav ... See More
select title, uk_release_date, count(*) from films group by title, uk_release_date having count(*) > 1;