4 Please write a querry to find repeated numbers in the
following table.
Table Name: Table1
Field1
10
15
20
15
10
- 7 Answers
- 7975 Views
- I also Faced
- E-Mail Answers
Answer Posted / pritesh
SELECT field1
FROM table1
GROUP BY field1
HAVING COUNT(field1)>1;
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration
Do you know what are the ways available in sql server to execute sql statements?
Tell me what is difference between view and materialized view?
What are scalar functions in sql?
What is ms sql server reporting services?
How to generate create procedure script on an existing stored procedure?
What does <> symbol mean?
What is the use of tempdb? What values does it hold?
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
Explain the commands in sql server?
How to create new table with "create table" statements?
What is the importance of three tier architecture?
as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration
Explain what is row_number function?
Can you explain what is the use of custom fields in report?
