answersLogoWhite

0


Best Answer

select name ,count(name) from #tem group by name

having count(name) > 1

User Avatar

Wiki User

14y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Write a SQL database query to retrieve the repeated names from the student table?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is a transactional database?

A Transactional Database is a DBMS where write operations on the database are able to be rolled back if they are not completed properly.


How can exponents make it easier to write an expression with a repeated factor in the product?

how can exponent can make it easier to write an expression with a repeated factor in the product


Describe the database recovery process and the use of deferred-write and write-through techniques?

deferred-write: The transaction do not immediate update database, instead, only update log file. Then when transaction reach commit point, it will update the physical database. write-through: The database is update right away during the transaction execution.


How do you write 4.7 repeated as a mixed number?

If by "4.7 repeated" you mean 4.77777777...., then it is 47/9.


How to write repeated multiplication of a factor by using an exponent?

To write repeated multiplication in an exponential notation, you should write the number that has to be multiplied as the base. Count the number of times that the number is used.


Can you write small repeated sections within larger repeated sections in music?

Not unless the larger section is repeated using D.C./D.S. markings.


How do you write 79 repeated as a fraction?

79/99


Connect c language to internet database?

Yes, you can write a program in C language which connects to a database.


What is database server and how they works?

A database is a collection of tables in which large quantities of data (information) can be stored. The question and answer you are looking at right now are both stored in a database, for example. Databases are used by applications (like websites) to store and retrieve data.


How do you design a database?

hmm, I start to think what am will doing with database, usually I write firts all my idea on a paper and when it ready to build, I use my database application.


Is it possible to perform a calculation within a database?

Yes you can. You can create queries that do calculations. You can write code for programs to do calculations in a database. Doing calculations is a significant element of what you do with a database, so yes you can do them within a database.


Write the detail of sql?

SQL is a database programming language.By this language we can create ,modify and other updating of our database record.