What are analytical functions in sql?
No Answer is Posted For this Question
Be the First to Post Answer
How do you remove duplicates without using distinct in sql?
explain the delete statements in sql
What is the difference between unique and primary key constraints?
Does asenumerable execute the query?
What are the usages of sql?
What is mdf ldf and ndf?
What is difference between rank () row_number () and dense_rank () in sql?
what is difference b/w pravite procedures and public procedures?
3 Answers Steria, Wipro, Zensar,
counting the no.of characters occurs in a string by using pl/sql function
How to remove duplicate rows from a table?.
one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows only how should u write query?
select 10 from dual; y its showing all the rows with 10?
Oracle (3253)
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)