Answer Posted / rajesh.a
select count(*),empname from emp group by empname having count(*)>1
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?
Tell me what is the difference between locking and multi-versioning?
What is thr feature of change data capture?
What are the difference between clustered and a non-clustered index?
How we create SQL Server 2005 Reporting Services ? Give me Sample
How to use user defined functions in expressions?
What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
Explain what are the basic functions for master, msdb, model, tempdb databases?
How do I perform an unattended install of sql server 2000?
how you can get the list of largest tables in a database? : Sql server administration
What are views in ms sql server?
What is the difference between a function and a stored procedure?
What is sql azure database?
What is an indexing technique?