Interested to Buy Any Domain ? << Click Here >> for more details...
We need to compare two successive records of a table based
on a field. For example, if the table is CUSTOMER, and the
filed is Account_ID, To compare Account_IDs of record1 and
record2 of CUSTOMER table, what can be the query ?
- 3 Answers
- 5081 Views
- I also Faced
- E-Mail Answers
Answer Posted / suman rana
select * from
(SELECT account_id , lead(account_id, 1, 0) over (order by
1) nxt_account_id FROM customer)
where account_id = nxt_account_id
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain what are synonyms used for?
How many memory layers are in the oracle shared pool?
What is the simplest tool to run commands on oracle servers?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
Explain user account with reference to oracle.
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
How would you go about verifying the network name that the local_listener is currently using?
What is tns service name?
What is SQL access advisor in Oracle?
What is the difference between primary key and unique key and foreign key in oracle?
How to connect to oracle using service name instead of sid?
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
Why we use bulk collect in oracle?
How do I know if oracle client is installed on windows?
Does oracle partitioning improve performance?
