Interested to Buy Any Domain ? << Click Here >> for more details...
employee table has employee id
-----------
empid
----------------
1
2
3
3
3
4
5
5
5
6
6
6
7
here the values r repeated two times.how to select the
repeated values only.i.e 3,5,6 should alone come.
- 3 Answers
- 7805 Views
- I also Faced
- E-Mail Answers
Answer Posted / rajesh kumar
select empid from employee where empid in (select empid
from employee group by empid having count(empid) > 1)
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is bcp? When does it used?
What is the distinction amongst delete and truncate?
Sql server reporting services vs. Crystal reports.
What number aggregate functions are accessible there in sql?
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
What is the difference between mysql and mysqli?
What is the usage of sign function?
What is intellisense?
What command is used to delete a table from the database in the sql server and how?
What is dbcc?
How do users use Report Builder with SQL Server data sources?
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
Is the log file is a part of file group?
What is delete query?
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
