Interested to Buy Any Domain ? << Click Here >> for more details...
how to delete duplicate rows from a specified table(only
single table)
how do you know which join is need to be used
- 11 Answers
- 19247 Views
- UST, I also Faced
- E-Mail Answers
Answer Posted / lakshya
SELECT * FROM table_name
WHERE ROWID NOT IN (SELECT MIN(ROWID) FROM table_name GROUP
BY table_columns);
| Is This Answer Correct ? | 9 Yes | 8 No |
Post New Answer View All Answers
Is oracel sql developer written in java?
Why triggers are used?
What is the difference between microsoft sql and mysql?
What is offset and limit in sql?
What is the difference between function and procedure in pl/sql?
how to shut down the server with 'mysqladmin'? : Sql dba
how can we know the count/number of elements of an array? : Sql dba
What plvcmt and plvrb does in pl/sql?
Does postgresql run on the cloud?
Explain exception handling in pl/sql?
How do I order columns in sql?
How do I view a sql database?
First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.
how to analyze tables with 'mysqlcheck'? : Sql dba
what are date and time data types in mysql? : Sql dba
