Give me a command in SQL to display details of a employee whose name is D'souza?

Answer 1

.

Select * from employee where name like 'D?souza'

**********
Vasu M
**********

Answer 2

suppose u r using table emp which has an attribute ename and others so many . u want to know the record of an emp whoose name is D'souza , write down it and execute it


select * from emp where ename ="D'souza"

Answer 3

Imagine your table name is employee and the field name for storing names of the employee's in the employee table is ename , then the query will be like this.


select * from employee where ename='dsouza';

Answer 4

Is the problem the single quote? Try 'D\'souza'. I'm not an SQL guy, but it's worth a try.

Answer 5

Assuming you have a table named table, and a name column named columnname, and the name column contains both first and last names:

For MySQL:

SELECT * FROM table WHERE columnname LIKE '%D\'Souza%'

For Transact-SQL (Microsoft):

SELECT * FROM table WHERE columnname LIKE '%D''Souza%'

Answer 6

Select * from table name
where name like 'D's%'

Answer 7

select * from table_name
where name = 'D''souza';

Use two single quotes after D.

Answer 8

SELECT *
FROM complete
WHERE lName="D'souza";

Answer 9

it's very simple,

Use escape in the query....

Answer 10

-\displayE "D'souza" end/