Register

Recent questions tagged sql

1 votes
0 answers
302
sql assertion
User Avatar
2 votes
2 answers
303
Aggregate function
Can we apply min and max (aggregate function in sql) on strings and date datatype ? Query :SELECT max(Name) FROM EMPLOYEE what will be the result ?
Can we apply min and max (aggregate function in sql) on strings and date datatype ?Query :SELECT max(Name) FROM EMPLOYEEwhat will be the result ?
User Avatar
7 votes
0 answers
304
#SQL-DBMS
Q.consider following relation; supplier(sid,sname,rating)/sid is the p.k parts(pid,pname,color)/pid is the p.k catalog(sid,pid,cost)/sid,pid is the p.k Write SQL command for : retrieve sid supplied every red parts but not any green parts.
Q.consider following relation;supplier(sid,sname,rating)/sid is the p.kparts(pid,pname,color)/pid is the p.kcatalog(sid,pid,cost)/sid,pid is the p.kWrite SQL command for ...
User Avatar
2 votes
0 answers
305
dbms query
how min() and max() work with non numeric value?
how min() and max() work with non numeric value?
User Avatar
2 votes
0 answers
306
SQL Duplicate columns
Assume i have two tables R(A,B) and S(A,D) 1. Select * from R,S 2. Select * from R,S where R.A>S.A What will be the name/number of columns on both of these cases?
Assume i have two tables R(A,B) and S(A,D)1. Select * from R,S2. Select * from R,S where R.A>S.AWhat will be the name/number of columns on both of these cases?
User Avatar
2 votes
1 answer
307
sql aggregate function
Given a column consisting of 12,19,12,13,14,NULL,NULL. What will be the answer 1.If we apply count on the column. 2.If we apply sum on the column. 3.If we apply avg on the column. 4.If we apply count(*) on the column. Please provide the explanation whether to count null or not.
Given a column consisting of 12,19,12,13,14,NULL,NULL. What will be the answer1.If we apply count on the column.2.If we apply sum on the column.3.If we apply avg on the ...
User Avatar
0 votes
1 answer
309
DBMS SQL
Trigger code written in SQL or PL/SQL???? Please explain it
Trigger code written in SQL or PL/SQL???? Please explain it
User Avatar
9 votes
2 answers
310
ISRO2017-7
... Employee, Department from Overtime_allowance) natural join (select Department, OT_allowance from Overtime_allowance) as T); $16$ $4$ $8$ None of the above
$\begin{array}{|l|l|l|l|l|} \hline \textbf{Employee} & \textbf{Department} & \textbf{OT_allowance} \\ \hline \text{RAMA} & \text{Mechanical} & \text{5000} \\\hline \text{...
User Avatar
44 votes
3 answers
320
GATE CSE 2017 Set 2 | Question: 46
Consider the following database table named $\text{top_scorer}$ ... tc.goals FROM top_scorer AS tc WHERE tc.country='Germany') The number of tuples returned by the above SQL query is ______
Consider the following database table named $\text{top_scorer}$.$$\overset{\text{top_scorer}}{\begin{array}{|c|c|c|}\hline\\\textbf{player}& \textbf{country}& \textbf...
User Avatar
3 votes
1 answer
327
SQL query
how is q1 right it only shows sid for students with rank less than everyone
how is q1 right it only shows sid for students with rank less than everyone
User Avatar
0 votes
2 answers
330
MadeEasy Subject Test: Databases - Sql
User Avatar
Page: