How would you retrieve Unique rows from table without using UNIQUE and DISTINCT keyword?
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 |
Write a query for primary key constraint with identity key word?
Do you know spatial data types - geometry and geography in sql server 2008?
What is Index ? Explain its Types?
Why de-normalization required?
What the different types of Replication and why are they used?
Write the SQL query to drop, truncate and delete table.
0 Answers HPCL, Hughes Systique Corporation, Ittiam Systems,
What is the use of stored procedure?
What is RMS migrations?
what is a transaction? : Sql server database administration
What is transaction server isolation?
What is difference between TRUNCATE and DELETE statement
How much is a sql server license?
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)