in emptable i want to retrive the name of employee whose
name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.
Answer Posted / nithya_raghu
select * from emp where empname like J%
Is This Answer Correct ? | 0 Yes | 7 No |
Post New Answer View All Answers
How retrieve field names from the table in SQL through JAVA code?
What is cross join in sql server joins?
Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
What is server-level principal?
How can you append an identity column to a temporary table?
What is system stored procedures?
What are different types of subquery?
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?
where can you add custom error messages to sql server? : Sql server administration
How can you tell if a database object is invalid?
Explain the first normal form(1nf)?
How do use Having,Group by,Group function in SQL?
How to generate random numbers with the rand() function in ms sql server?
How to create a new schema in a database?