Question

1 point
Select the SQL query which
displays the details of students'
RAM and RAHIM from the
student table. *
SELECT * from student where name
= 'RAM' or 'SHYAM';
SELECT * from student where name
= 'RAM' and 'SHYAM;
SELECT * from student where name
= 'RAM' or name ='SHYAM';
SELECT * from student where name
= 'RAM' and name ='SHYAM';
!​

Answer 1

Answer:

right

Explanation:

as its related to each other as a

Answer 2

From the given question the correct answer is :

SELECT * from student where name = 'RAM' and name ='SHYAM';

AND Operator:

This operator displays only those records where both the conditions condition1 and condition2 evaluates to True.  

Syntax:  

SELECT * FROM table_name WHERE condition1 AND condition2 and ...conditionN;

table_name: name of the table

condition1,2,..N : first condition, second condition and so on

the SQL query which  displays the details of students'  RAM and RAHIM from the  student table. SELECT * from student where name = 'RAM' and name ='SHYAM';