4 Please write a querry to find repeated numbers in the
following table.
Table Name: Table1
Field1
10
15
20
15
10
- 7 Answers
- 7983 Views
- I also Faced
- E-Mail Answers
Answer Posted / phani
select distinct field1 from table1
| Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
How to find the login name linked to a given user name?
How exceptions can be handled in sql server programming?
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
How to select all columns of all rows from a table with a select statement in ms sql server?
What is difference between rownum and row_number?
The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio
How to get the number of affected rows?
What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?
What are the differences between stored procedure and the dynamic sql?
List out a number of the wants to setup a SQL Server failover cluster?
What is the difference between the 2 operating modes of database mirroring?
What are the difference between primary key and unique key? : sql server database administration
How do you know if sql server is running on your local system?
What are the restrictions applicable while creating views? : SQL Server Architecture
What is an indice?
