4 Please write a querry to find repeated numbers in the
following table.
Table Name: Table1
Field1
10
15
20
15
10
Answer Posted / arun kumar
SELECT Field1 FROM Table1 WHERE Field1%5=0
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
what is the difference between a primary key and a unique key? : Sql server database administration
Explain difference between control flow and data flow?
What are ddl triggers and types of ddl trigger?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
Which is the best place or learning center for MS SQL?????In Bangladesh?????
Can you explain different types of joins?
Issues related in upgrading SQL Server 2000 to 2005 / 2008
What does sql server mean?
Define cross join in sql server joins?
What is the difference between insensitive and scroll cursor?
What is policy management?
What does nvl stand for?
How to change server name in sql server?
Why would you call update statistics?
How can we check the sql server version?