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
- 9157 Views
- I also Faced
- E-Mail Answers
Answer Posted / phani
select distinct field1 from table1
| Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
What is bit data type? What's the information that can be stored inside a bit column?
what is the difference between a primary key and a unique key? : Sql server database administration
How to backup SQL Server Reporting Services ?
What is the recovery model?
What are the requirements to use odbc connections in php scripts?
What is the purpose of update statistics and scope_identity() function?
How to send email from database?
What is in place upgrade in sql server?
How do you know if sql server is running on your local system?
What are the restrictions that views have to follow? : SQL Server Architecture
Create and insert into temp table in sql server?
What are the difference between primary key and unique key? : sql server database administration
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 is cursor in ms sql server?
How to add additional conditions in SQL?
