Answer Posted / pavan

Hi,
try this query.In this query sal one val is duplicated
4items


select sal,count(sal) from test group by sal having count
(*)>1

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?

894

---

Can you please explain the difference between function and stored procedure?

970

---

How to display a past time in days, hours and minutes?

978

---

What are the disadvantages of using the stored procedures?

1031

---

What are the joins in sql server? : sql server database administration

975

---

What are the aggregate and scalar functions?

1003

---

What is the difference between TRUNCATE and DROP?

1078

---

What are a scheduled jobs or what is a scheduled tasks?

863

---

What are the advantages of stored procedure in sql server?

845

---

How extra digits are handled with numeric data type literals?

923

---

What are the kinds of subquery?

963

---

What do you understand by mirroring and mention the advantages of the mirroring?

1016

---

after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

2047

---

Define magic tables in sql server?

1005

---

Can we perform backup restore operation on tempdb? : sql server database administration

954

---