Answer / saurav kumar

table: employee; column name: lastname

select * from employee where lastname like '%n'

Answer / anshu sharma

SELECT * FROM TABLE_NAME WHERE EMP_LASTNAME LIKE 'N%'

create table with fields ID, reserved_by,res_date res_date is datefield like 2010-03-09 00:00:00.000 from 2005 to 2006 any date assume based on res_date need to slect table and display based on month (full jan details in database irrespective of date and year

3 Answers  

---

Do you know data definition language, data control language and data manipulation language?

0 Answers  

---

what is statistics

1 Answers  

---

What are types of subqueries?

0 Answers  

---

How to find out name of all employees who has salary less than 200 Rs.?

8 Answers  

---

---

What is the difference between IN and EXISTS operators in SQL Server?

9 Answers   ASD Lab, CSC, Intelligroup,

---

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

0 Answers   iSoft,

---

What are the properties of sub-query?

0 Answers  

---

What is the maximum size of a dimension? : sql server analysis services, ssas

0 Answers  

---

List out different types of normalizations in sql server and explain each of them?

0 Answers  

---

How do I start sql server 2016?

0 Answers  

---

What is Transaction?

2 Answers  

---