Interested to Buy Any Domain ? << Click Here >> for more details...
4 Please write a querry to find repeated numbers in the
following table.
Table Name: Table1
Field1
10
15
20
15
10
- 7 Answers
- 9047 Views
- I also Faced
- E-Mail Answers
Answer Posted / vivek
Select distinct Field1 from Table1 where Field1 between 10
and 15
| Is This Answer Correct ? | 2 Yes | 17 No |
Post New Answer View All Answers
Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?
What is the osql utility?
How to use the inserted and deleted pseudo tables?
What are “lost updates”?
What new data source types were added in ssrs 2014?
How to generate random numbers with the rand() function in ms sql server?
What are the various Operating system files that every SQL server 2005 database has and what is the purpose.
What happens if you add a new index to large table?
How to transfer a table from one schema to another?
How to replace the Query Result 'Null Value' with a text ?
What is the difference between local and global temporary tables?
What are key constraints?
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
What are the dmvs?
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
