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
If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?
Can we check locks in database? If so, how can we do this lock check?
What are various limitations of the views?
Explain the relational database management system (rdbms)?
What is exclusive locks?
How do you send email on SQL Server?
Why is normalisation important?
if no size is defined while creating the database, what size will the database have? : Sql server administration
How do I schedule a sql server profiler trace?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
What is the cpu pressure?
Difference between connected and disconnected database in .net with sql server?
When columns are added to existing tables, what do they initially contain?
What are partitioned views and distributed partitioned views?
What is the maximum size of a dimension? : sql server analysis services, ssas