Interested to Buy Any Domain ? << Click Here >> for more details...
How would you retrieve Unique rows from table without using UNIQUE and DISTINCT keyword?
- 2 Answers
- 3155 Views
- Genpact, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / jayanth
using union
select * from tableA
union
select * from tableB
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / virendra maurya
We can simply remove duplicate from table
1. Using CTE
2. Using Group by
3. Using Rank function
| Is This Answer Correct ? | 0 Yes | 1 No |
What is blocking?
How to add a new dsn with the odbc driver for sql server?
How does using a separate hard drive for several database objects improves performance right away?
When to use Inner join & when to use subquery?
How retrieve field names from the table in SQL through JAVA code?
Explain about merge replications?
What is the difference between createstatement and preparedstatement?
How can you append an identity column to a temporary table?
Is it ok to shrink transaction log?
What method is used by the Command classes to execute SQL statements that return single values?
Can we create clustered index on non primary key column
20 Answers ABC, CTS,
What is advantage data architect?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
