Does a join table need a primary key?
No Answer is Posted For this Question
Be the First to Post Answer
What is a recursive stored procedure?
how will you find out the last three records in a table with n no of records and delete them
how to get the third quarter of employee details from emp?
What are the different type of joins in sql?
what is the correct way of selection statement a. select/from/table_name/orderby/groupby/having b. select/from/table_name/groupby/having/orderby
5 Answers HCL, JPMorgan Chase,
How do you write a complex sql query?
Can we call dml statement in function?
Why functions are used in sql?
What is varchar used for?
What is diff between bulk collect and forall
What is a subquery in sql?
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?
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)