If there are 1 to 100 numbers in a table and in that 100
numbers some 10 numbers are deleted.I want to find out the
missing numbers between 1 to 100 by pl/sql how?
Answer Posted / sureshramsing@gmail.com
select level from dual connect by level<=100 minus select <column name> from <table name>;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Is ms sql is free?
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
What does stand for in sql?
What is the difference between local and global temporary table?
How do I view tables in mysql?
How does cross join work?
What is bitemporal narrowing?
what is a table in a database ? : Sql dba
Which certification is best for sql?
Define a temp table?
What do you mean by “trigger” in sql?
How do you change a value in sql?
How many types of tables are there?
What are the types of dbms?
Is sql database free?