How will you write a query to get a 5th rank student from a table student_report?
No Answer is Posted For this Question
Be the First to Post Answer
Explain the difference between a procedure and a function? What do you understand by those terms?
What is indexing, and how does it improve performance?
Given two table employee and department EMP ---------------- empid deptid(fk) Dept --------------------- deptid(pk) deptname que-Write a query to find count of employee in each department. Expected Output- deptid countofEmployee --------------------------- 10 57 20 20 30 15
Can multiple columns be used in group by in oracle?
What are the differences between primary key and unique key?
Explain the use of analyse option in exp command.
How to convert characters to numbers in oracle?
write a sql query following source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want the output column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c
Explain the use of show option in imp command.
please explain.. DB architecture ...
Who developed oracle & when?
what is difference between foreign key and reference key