What is mean by TCL, What are its commands?

mallika

• Apr 26th, 2016

Transaction control language and commands are commit, rollback and save point

Anubha Bisht

• Apr 18th, 2016

Transaction Control Language

1. Commit
2. Rollback
3. SavePoint
4. Set Transaction

Answer Question  Select Best Answer

I have a table with duplicate names in it. Write me a query which returns only duplicate rows with number of times they are repeated?

yuvaevergreen

 Profile Answers by yuvaevergreen Questions by yuvaevergreen

• Jun 14th, 2011

The answer by me is for teradata

yuvaevergreen

 Profile Answers by yuvaevergreen Questions by yuvaevergreen

• Jun 14th, 2011

sel name,count(*) from retail.yuvagroup by 1 order by 2 having count(*) >1

Answer Question  Select Best Answer