50 views
0 votes
0 votes
NTA PhD Entrance Examination CS  2023| Part 2  Question-37

Consider the following table, named as ' $a$ ', and answer the given query.
\begin{tabular}{|c|c|}
\hline Name & ID \\
\hline Amit & 1 \\
\hline Shweta & 2 \\
\hline Lavanya & 3 \\
\hline Rohit & 4 \\
\hline Isha & 5 \\
\hline
\end{tabular}

How many rows will be returned by the following query?
SELECT *
FROM a p, a q, a r
WHERE p.id $<$ q.id<br /> AND q.id < = r.id;
1. 10
2. 20
3. 30
4. 40

Please log in or register to answer this question.

Related questions

0 votes
0 votes
0 answers
1
0 votes
0 votes
1 answer
2
admin asked Dec 2, 2023
166 views
Question No. 1 / Question ID 974051Marks: 4.00The number of divisors of 2100 is1. 422. 363. 784. 721 (Chosen Option)234
0 votes
0 votes
1 answer
4
admin asked Dec 2, 2023
143 views
Question No. 3 / Question ID 974076Marks: 4.00void main()\{int $\mathrm{i}$;for $(i=0 ; i