COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Write a query to draw out details of all the employees whose name starts with ‘A’ or are based in Pune.
|
|
SELECT * DataFlair WHERE name location = ‘Pune’;
|
|
|
SELECT * FROM DataFlair WHERE name LIKE ‘%A ____ ‘ or location = ‘Pune’;
|
|
|
SELECT * FROM DataFlair WHERE name LIKE ‘A%’ or location = ‘Pune’;
|
|
|
None of the above.
|
Explanation:
Detailed explanation-1: -D. Explanation : DDL commands are used to define the structure of the database, table, schemas, etc.
Detailed explanation-2: -Write an SQL query to print details of the Workers whose FIRST NAME contains ‘a’. Ans. The required query is: Select * from Worker where FIRST NAME like ‘%a%’;
Detailed explanation-3: -Write An SQL Query To Print Details Of The Workers Whose FIRST NAME Ends With ‘H’ And Contains Six Alphabets. Ans. The required query is: Select * from Worker where FIRST NAME like ‘ h’;
There is 1 question to complete.