Interested to Buy Any Domain ? << Click Here >> for more details...
how to find out the repeated value from table using groupby
function?
- 4 Answers
- 7139 Views
- I also Faced
- E-Mail Answers
Answer Posted / karthik
select eno,count(1) cnt from emp
group by eno having count(1) > 1;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to get a list of columns using the "sp_help" stored procedure in ms sql server?
What is the primary use of the model database?
What are magic tables in sql server?
Explain about thread and memory management process of SQL?
What is co-related sub query?
When multiple after triggers are attached to sql table, how to control the order of execution?
What is difference statement and preparedstatement?
What is 2nf in normalization?
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
What is ms sql server triggers?
Define Business Edition in SQL Azure?
Can we use where and having clause together?
What is deploy, process and build? : sql server analysis services, ssas
What is the data type of time?
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
