write a query which empname starts with A

Question Posted / nandini p

Answers were Sorted based on User's Feedback

write a query which empname starts with A..

Answer / sneha.va

SELECT * FROM TABLE_NAME
WHERE EMPNAME LIKE 'A%'

Is This Answer Correct ?

18 Yes

0 No

write a query which empname starts with A..

Answer / nandini p

using %
in where empname like 'A%

Is This Answer Correct ?

8 Yes

0 No

write a query which empname starts with A..

Answer / jako

Select * from table_name where empname like 'A%'

Is This Answer Correct ?

3 Yes

0 No

write a query which empname starts with A..

Answer / bharath

select * from tab_name where upper(ename) like 'A%';

Is This Answer Correct ?

2 Yes

0 No

write a query which empname starts with A..

Answer / viraj

Select * From Emp
where
empname ilike 'A%

Is This Answer Correct ?

3 Yes

1 No