Dark Mode

Recent questions tagged sql

1 vote

2 answers

1

GATE CSE 2023 | Question: 51
Consider the following table named $\text{Student}$ in a relational database. The primary key of this table is $\text{rollNum}.$ $\text{Student}$ ... database. SELECT * FROM Student WHERE gender = 'F' AND marks > 65; The number of rows returned by the query is ___________.

admin asked in Databases Feb 15

by admin

898 views

0 votes

1 answer

2

Will not Exist(cc in T1 is not equal to T2) gives TRUE ? , can anyone explain this

abhinowKatore asked in Databases Jan 18

by abhinowKatore

70 views

0 votes

0 answers

3

SQL | Not Exist

abhinowKatore asked in Databases Jan 17

by abhinowKatore

57 views

0 votes

1 answer

4

SQL Query
Write SQL command to find DepartmentID, EmployeeName from Employee table whose average salary is above 20000.

rayhanrjt asked in Databases Jan 6

132 views

1 vote

0 answers

5

DRDO CSE 2022 Paper 2 | Question: 14
A relational database contains two tables movie, and genre, in which movie table has columns movie_no, movie_name, and genre_id, while genre table has columns genre_id, and genre_name. Following insert statements were executed successfully to populate the ... How many rows and columns will be retrieved by the following SQL statement? Select * from movie, genre

admin asked in Databases Dec 15, 2022

by admin

57 views

0 votes

1 answer

6

#gate cs applied course

Dknights asked in Databases Dec 12, 2022

93 views

0 votes

1 answer

7

#gate cs applied course
how both query result is the same, please give an example.

Dknights asked in Databases Dec 12, 2022

81 views

0 votes

0 answers

8

DBMS EXAM Question
Write an SQL query For every company -- including companies with no divisions -- find, and output, the company and the number of divisions it has. In this question you may not use any embedded SFW's, nor may you use any embedding operators, ... <relational operator> SOME, or <relational operator> ANY. Additionally, you may use GROUP BY, but you may not use HAVING.

rkumar16 asked in Databases Nov 16, 2022

108 views

0 votes

0 answers

9

Best Open Video Playlist for SQL Topic | Databases
Please list out the best free available video playlist for SQL from Databases as an answer here (only one playlist per answer). We'll then select the best playlist and add to GO classroom video lists. You can add any video playlist ... ) but standard ones are more likely to be selected as best. For the full list of selected videos please see here

makhdoom ghaya asked in Study Resources Aug 20, 2022

by makhdoom ghaya

95 views

0 votes

0 answers

10

ISI2020-PCB-CS: 5
In a conference, the relation, $\textsf{registered (participant, topic)}$ stores the names of participants and the topics registered by them. The primary key for this relation is $\textsf{(participant, topic)}.$ ... . Which strategy is faster for $x=3000?$ Justify your answer. Which strategy has less disk access time? Justify your answer.

Lakshman Patel RJIT asked in Databases Aug 8, 2022

by Lakshman Patel RJIT

58 views

1 vote

1 answer

11

Write SQL query
Write SQL query to show all employees hired on June 4,1984 (non-default format) emp(empno,ename,job,mgr,hiredate,sal,comm,deptno)

Subhrangsu asked in Databases Jun 18, 2022

205 views

0 votes

1 answer

12

SQL Query Question
Consider the relational database given below. Give an expression in SQL for each of the following queries. employee (person-name, street, city) works (person-name, company-name, salary) company (company-name, city) manages (person-name, manager-name) a. ... such cases, give only a 3 percent raise e. Delete all tuples in the works relation for employees of Small Bank Corporation.

varun29 asked in Databases Apr 28, 2022

1.6k views

1 vote

1 answer

13

Self Doubt
I want to join the two tables of movies and actors and then output only those results that have gender =”F”, can you tell me where I am going wrong?

tusharb asked in Databases Mar 27, 2022

338 views

Page:

1
2
3
4
5
6
...
16
next »

Recent questions tagged sql