Register

Recent questions tagged sql

2 votes
1 answer
61
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)
Write SQL query to show all employees hired on June 4,1984 (non-default format)emp(empno,ename,job,mgr,hiredate,sal,comm,deptno)
User Avatar
1 votes
1 answer
63
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?
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?
User Avatar
0 votes
2 answers
65
What would be the result of this query
Source Made Easy Test Serires Can anyone please tell me the answer for this, with explaination. According to me it will give the customer who buy from atleast one store, but the answer given is customer who buy from all stores.
Source Made Easy Test SeriresCan anyone please tell me the answer for this, with explaination. According to me it will give the customer who buy from atleast one store, b...
User Avatar
0 votes
2 answers
66
SQL - databases
Consider the following relations: How many number of records will be returned by the following query?
Consider the following relations:How many number of records will be returned by the following query?
User Avatar
1 votes
1 answer
69
SQL - outer join - ACE workbook
An outer join can be done between: a. only two tables b. only three tables c. any number of tables
An outer join can be done between:a. only two tables b. only three tables c. any number of tables
User Avatar
1 votes
1 answer
73
NIELIT Scientific Assistant A 2020 November: 45
$(<\text{ALL})$ comparison operator means: more than the maximum value in the subquery less than the minimum value in the subquery is equivalent to $\text{IN}$ none of the options
$(<\text{ALL})$ comparison operator means:more than the maximum value in the subqueryless than the minimum value in the subqueryis equivalent to $\text{IN}$none of the op...
User Avatar
1 votes
1 answer
74
NIELIT Scientific Assistant A 2020 November: 91
With the following syntax INSERT INTO table[(column[,column...])] VALUES (value[, value...]); you can: Insert one row at a time Insert multiple rows at a time Insert one column at a time Insert multiple columns at a time
With the following syntaxINSERT INTO table[(column[,column...])] VALUES (value[, value...]);you can:Insert one row at a timeInsert multiple rows at a timeInsert one colum...
User Avatar
1 votes
1 answer
75
NIELIT Scientific Assistant A 2020 November: 98
When retrieving data in particular table in PostgreSQL, we use the ______ statement. \dt ORDER BY SELECT FROM \i
When retrieving data in particular table in PostgreSQL, we use the ______ statement.\dtORDER BYSELECT FROM\i
User Avatar
Page: