How can we make an if statement within a select statement?
No Answer is Posted For this Question
Be the First to Post Answer
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 in the table permanently and i want output in the above formatow should u write query?
What is set serveroutput on in pl sql?
Which constraints we can use while creating database in sql?
What are three advantages to using sql?
How do you take the union of two tables in sql?
What is a CTE (Common Table Expression), and how is it different from a subquery?
What is the difference between row level and statement level trigger?
What is trigger in sql and its types?
What is the difference between execution of triggers and stored procedures?
Does inner join remove duplicates?
What is primary key secondary key alternate key candidate key?
What is Referential Integrity?
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)