in emptable i want to retrive the name of employee whose
name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.
Answer Posted / faridha
select * from emp where ename like 'J%' or '%J' and
not like ('arjun','jagadesh','niranjan','anju','aaaj');
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How to implement service broker?
What does dml stand for?
What happens if the update subquery returns multiple rows in ms sql server?
Explain SSRS Architecture?
Which Model uses the SET concept
What is the difference between local and global temporary tables?
What is the maximum size per database for sql server express?
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
Explain the categories of stored procedure?
What is indexing in sql server with example?
What is acid properties?
How to display a past time in days, hours and minutes?
Why do we use sql limitations? Which constraints can we use while making a database in sql?
What is an expression in ms sql server?