Interested to Buy Any Domain ? << Click Here >> for more details...
in emptable i want to retrive the name of employee whose
name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.
- 8 Answers
- 9170 Views
- I also Faced
- E-Mail Answers
Answer Posted / deepa
For those who names starts with letter J is
select * from emp where name like 'j%'
For those who names with letter J is
select * from emp where name like '%j%'
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
What is temporal data type?
Write a sql query to get zero records from a table having n number of records?
What is the difference between dataadapter and datareader?
What is the difference between cartesian product and cross join?
How do I create a partition table in sql server?
Can the query output be sorted by multiple columns in ms sql server?
Benefits of Stored Procedures?
How to list all login names on the ms sql server?
What is the order by used for?
How to find the second highest salary of an employee?
What is the difference between ddl,dml and dcl commands?
where the connection string store in the database
Data table as parameter in sql server?
What are trace flags and mention a few common trace flags used with sql server?
Find nth lowest salary or get nth lowest salary?
