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
- 7662 Views
- I also Faced
- E-Mail Answers
Answer Posted / vijendra singh shakya
For Employee table plz use the following Query...
select [empid] from employee group by [empid]
having count(empid)>1
| Is This Answer Correct ? | 17 Yes | 0 No |
Post New Answer View All Answers
What are the three different part of rdl file explain them?
How to change the ownership of a schema in ms sql server?
Explain the dbcc pintable command when would you use it?
Mention the uses of stored procedures.
How do you manipulate data?
Explain transaction isolation levels in sql server?
What is single-user mode and what are the steps you should follow to start sql server in single-user mode?
How to reaname table name without using sp_Rename in sql server..?
What are the advantages of policy management?
How can sql server instances be hidden? : sql server security
How to use “drop” keyword in sql server and give an example?
If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?
Is sql server is free?
