Relational query

Deepalitrapti asked Aug 9, 2018

164 views

0 votes

Emp(eid,sal,dno) eid the the primary key

1. Retrieve eid whose salary 2nd highest

2. Retrieve eid whose salary maximum for each department

Write the relational query

Deepalitrapti asked Aug 9, 2018

Deepalitrapti

164 views

See all

0 Please log in or register to add a comment.

Please log in or register to answer this question.

0 Answers

Voting & Accepting an answer helps improve the community

← Previous Next →

← Previous in category Next in category →

Related questions

1 votes

2 answers

Harsh Kumar asked Jul 2, 2018

1,798 views

Tuple Relational Calculus Query - Confirm the Answer
Relation Schema : Employee (Name, Ssn, Bdate, Address, Dept_number) Project (Pname, Pno, Dept_number) WorksOn (Essn, Pno, Hours) List the names of employees who work on all the projects controlled by department number 10. My Answer : ... name will be printed who work for some project at department no. 5 and not for the department no. 10 ?

Relation Schema : Employee (Name, Ssn, Bdate, Address, Dept_number)Project (Pname, Pno, Dept_number)WorksOn (Essn, Pno, Hours)List the names of employees who work on all ...

Harsh Kumar

1.8k views

Harsh Kumar asked Jul 2, 2018

Databases
tuple-relational-calculus
relational-calculus
databases

+ –

0 votes

0 answers

Amit puri asked Nov 16, 2016

142 views

tuple relational query
An undirected simple graph is represented as G(a,b) and a tuple x,y G if x and y are adjacent vertices. which of the following cannot be computed by a TRC query ? (A) Set of vertices who belongs to four length cycle (B) Set of vertices which have ... (C) Set of vertices which belongs to some cycle (D) Set of vertices which have degree n-1 where (n=total number of vertices)

An undirected simple graph is represented as G(a,b) and a tuple x,y G if x and y are adjacent vertices.which of the following cannot be computed by a TRC query ?(A) Set ...

Amit puri

142 views

Amit puri asked Nov 16, 2016

0 votes

0 answers

Sanjay Sharma asked May 18, 2016

212 views

relational calculus query

Sanjay Sharma

212 views

Sanjay Sharma asked May 18, 2016

0 votes

1 answer

Sanjay Sharma asked May 18, 2016

277 views

relational calculus query

Sanjay Sharma

277 views

Sanjay Sharma asked May 18, 2016

tags	tag:apple
author	user:martin
title	title:apple
content	content:apple
exclude	-tag:apple
force match	+apple
views	views:100
score	score:10
answers	answers:2
is accepted	isaccepted:true
is closed	isclosed:true

0 reply

Please log in or register to add a comment.

Please log in or register to answer this question.

0 Answers

Related questions

0