write a query which empname starts with A

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

Post New Answer

More Manual Testing Interview Questions

What is the difference between debugging and manual testing?

8 Answers   Siemens,


Please send any one latest 3+ years of experience testing tools resumes my mail id is krishnavenimodaliar26@gmail.com

0 Answers   ME,


i need manual testing interview questions for 2+ experience plzz help me..

1 Answers  


What is the testing process and what testing process followed by software company?

2 Answers  


what should we do if the developer rejects the bug?

2 Answers  






Defect management

1 Answers  


what is data base testing, explain with example

1 Answers   Crea,


what is the structure of test cases

3 Answers  


What is Registry?

0 Answers  


what is vss

2 Answers  


What is Build and what is Installation testing?

2 Answers   Covansys,


What r the three types of System testing

14 Answers   TCS,


Categories