⟩ How to find nth lowest salary?
For All SQL , Tested in PostgresSQL : Javedcc@gmail.com
SELECT * FROM <Table_Name> A
WHERE N = (SELECT COUNT(DISTINCT B.Column_Name ) FROM
<Table_Name> B WHERE A.Column_Name >= B.Column_Name)
For All SQL , Tested in PostgresSQL : Javedcc@gmail.com
SELECT * FROM <Table_Name> A
WHERE N = (SELECT COUNT(DISTINCT B.Column_Name ) FROM
<Table_Name> B WHERE A.Column_Name >= B.Column_Name)
Name the three major set of files on disk that compose a database in Oracle?
What are the four Oracle system processes that must always be up and running for the database to be useable?
What is the job of the information stored in data-dictionary?
Are the resulting relations of PRODUCT and JOIN operation the same?
How do you communicate with an RDBMS?
Which part of the RDBMS takes care of the data dictionary? How?
What are the primitive operations common to all record management systems?
What are the unary operations in Relational Algebra?
What do you mean by Correlated subquery?
What are database files, control files and log files. How many of these files should a database have at least? Why?