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
- 9345 Views
- I also Faced
- E-Mail Answers
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 a cube? : sql server analysis services, ssas
Describe triggers features and limitations?
What is the difference between varchar and varchar types?
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
What is clr ddl trigger?
What are the different authentication modes in sql server?
What are wait types?
Difference between drill down and drill through report.
Can we use max in where clause?
Explain syntax for viewing, dropping and disabling triggers?
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
What are the requirements for sql server 2016?
How do I view a procedure in sql server?
What is clustered index
What are constraints in microsoft sql server?
