Read Best Answer

Editorial / Best Answer

Answered by: Parished.D Chennai India

• Apr 24th, 2007

---

create table ee (eno int, ename varchar(200), sal int)

insert into ee values(1, 'a', 2000)
insert into ee values(2, 'b', 6000)
insert into ee values(3, 'c', 8000)

select ENO, ENAME, min(sal) AS SAL from ee group by eno,ename having min(sal) > 5000

Aman Gupta

• Jul 15th, 2024

SELECT Emp_Name, MIN(Salary) FROM Employee
GROUP BY Emp_Name
HAVING MIN(SALARY) > 5000

Arshad

• Jul 30th, 2023

SELECT ENO, SUM(SALARY)
FROM EE
GROUP BY ENO
HAVING SUM(SALARY) > 5000

Improve Answer

Sudha

• Apr 2nd, 2018

NULL is not a data type. The key word NULL is used to mention the unknown or missing values of data.
For ex: while registering sign up form there are few fields which are not mandatory and if user didnt fill those non mandatory fields then those values we can save it as null in the data table.

Dhileep

• Oct 24th, 2017

We cant able to mention particular data type for null.

Answer Question  Select Best Answer

Display employee name, designation, Dob who are born in the same year.

Emono ename Designation Dob
101 Raj Developer 24-06-1992
102 mahesh Engineer 15-06-1992
103 Rajesh Mechanic 02-02-1991
104 suresh Jr Engineer 01-01-1990

Afsar

• Oct 25th, 2017

TD QUERY:
SELECT EXTRACT (YEAR FROM DOB), ename, Designation, Dob
FROM TABLE TAB1
GROUP BY EXTRACT (YEAR FROM DOB)

Answer Question  Select Best Answer

How to delete duplicate records?

Naveen

• Jun 16th, 2017

Insert the distinct rows from the duplicate rows table to new temporary table. Delete data from table which has duplicate rows then insert the distinct rows from the temporary table

Raj Acharya

• Sep 30th, 2016

Using CTE ...you can remove duplicate records in one query....

Answer Question  Select Best Answer

How to extract the values from table based on the current date. How to write the query?

Select event_code from table name where date = sysdate

What will be added in the place of sysdate? This query will run daily to fetch the records.

Shiv

• May 18th, 2017

Select event_code from tablename where date=convert(varchar(10),getdate(),105)
GetDate() --- will give you the current date time
Convert function is used to convert the Date Time to Date
Using 105 code in the Convert function to convert it to DD-MM-YYYY Format

teja

• Mar 8th, 2017

GETDATE()

Answer Question  Select Best Answer

Write a query to display employee records having same salary department wise?

Empname Empsalary Empdep
a 1000 IT
b 1000 CSE

Sreeram

• Jul 30th, 2016

Code
 

Modather Seddik

• Aug 7th, 2015

Code
 

Answer Question  Select Best Answer

What are the challenges you have faced while using stored procedure?

How to read the data from a pdf in SSIS?

Amaleswar

• Jan 23rd, 2016

Using Import transformation.

Answer Question  Select Best Answer

badri

• Dec 9th, 2015

Can I write a trigger within Stored Procedure?

psingla

 Profile Answers by psingla Questions by psingla

• Mar 19th, 2010

No.Its automatically fired on DML statements.these can not be triggered manually.

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

Answered by: Steven

• Oct 4th, 2011

---

Normalizatiopn is the process of splitting tables up to reduce record redundancy. For instance if you have a table of addresses you may want to create a table of cities and link the addresses to the cities table in a foreign key. Since the city names would be identical on several records this would save a lot of space. In some cases if tables are not normalized the amount of space they would take up would be so large that it would not be possible to record the data. The amount of normalization that you choose would depend upon how often field data is repeated throughout the table.

Jatin Girdhar, Gurgaon

• Oct 12th, 2015

SQL Normalization is a systematic approach of de-composing tables to: 1. To eliminate redundant (useless) data 2. To store the data logically Benefits: 1. Removes Data redundancy 2. Improves perform...

rayudu

• Oct 11th, 2011

Normalizatilon is the process of organizing the table to minimize the redundency

Improve Answer

Explain Self Join with the help of an example?

Chaitali

• Sep 29th, 2015

Self join - Joining table itself called "Self join". In Self join we need to use alias for the same table.
Example -

SELECT E.EmpID, E.Name, M.Name As Manager Name
FROM Employee E SELF JOIN Employee M
WHERE E.MgrID = M.EmpID

asifeqbal

 Profile Answers by asifeqbal Questions by asifeqbal

• Mar 19th, 2015

The Join in which a table joined itself are called Self Join.

Code
 

Answer Question  Select Best Answer

I was asked a question in an interview, where I was given a situation which is:
I have registered to an online gaming website. It displays my rank on the basis of my score when I play a game.
Database table has 2 columns: 1. UserName 2. Score.
Since the login page was loading very slowly so the programmers created an non-clustered index on UserName and now the welcome page problem...

Yaman

• Aug 10th, 2015

First of all table is not well designed. Table should have a clustered index. Right now its a heap and if we create a clustered index on username its a bad idea as data gets physically sorted everytim...

nabin

• Mar 25th, 2015

create clustered index on name. Reason is clustered index should be applied on columns which do not change frequently. Since the user will register once and will not change name that frequently it is ...

Answer Question  Select Best Answer

In application supporter for .net, interviewer ask me how you support the application,but I could not answer properly. Please explain answer technically?

Ravi Sharma

• Jun 2nd, 2015

We provided end to end solutions. Taking the requirement from client side, analysis on that requirement. Providing the analysis documents. Starting developing part then testing and deployment.

Answer Question  Select Best Answer

Can i update views in SQL if yes in what scenarios?
if your view is joining multiple tables

Ayushi

• May 7th, 2015

We can update simple views(having data from one table) and complex views(having data from multiple tables) but columns should be taken from one base table for update.

asifeqbal

 Profile Answers by asifeqbal Questions by asifeqbal

• Mar 18th, 2015

Yes, we can update view when view is created by single table (simple view). If we want to Update view that are based on multiple tables using Joins, Update does not work. So we used "Instead of Triggers" for updating Complex view.

Answer Question  Select Best Answer

nabin

• Mar 25th, 2015

Normalization is all about reducing the redundancy where we segregate the data (a big row data) into multiple tables(does depend on various requirement and design) while maintaining the relationship b...

siva

• Apr 27th, 2012

It is good.I understood if you put some brief explanation with data, is very usable to the persons who are not understanding about normalization like me. ...

Answer Question  Select Best Answer

How to define unique key in table? Is it possible to define one primary key and one unique key in a single table?

asifeqbal

 Profile Answers by asifeqbal Questions by asifeqbal

• Mar 19th, 2015

UNIQUE key constraint enforce uniqueness of the column on which they are defined. It allows the column to have distinct & one NULL values. We can make one or more columns unique in a table by defining...

erik

• Jul 21st, 2012

SQL UNIQUE key... The UNIQUE constraint uniquely identifies each record in a database table. The UNIQUE and PRIMARY KEY constraints both provide a guarantee for uniqueness for a column or set of col...

Answer Question  Select Best Answer

what are difference between SqlDataAdapter ,SqlCommand and SqlDataReader

asifeqbal

 Profile Answers by asifeqbal Questions by asifeqbal

• Mar 19th, 2015

SqlDataReader are used to retrieve data in read-only forward-only manner from the data source. It is not used for traversing the data or writing it back to the data source. So SqlDataReader are faste...

santhosh

• Aug 6th, 2012

Sqldatareader means only read the datas in the table..
sqldataadapter means the datas read and writes

Answer Question  Select Best Answer

asifeqbal

 Profile Answers by asifeqbal Questions by asifeqbal

• Mar 19th, 2015

"c# SqlCommand command = new SqlCommand("dbo.sp_name", (SqlConnection)session.Connection); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new SqlParam...

asifeqbal

 Profile Answers by asifeqbal Questions by asifeqbal

• Mar 19th, 2015

Code
 

Answer Question  Select Best Answer

asifeqbal

 Profile Answers by asifeqbal Questions by asifeqbal

• Mar 19th, 2015

1. We can restrict the users access to the stored data by using Views. User can be given permission to access database through views that contain the specific data the user is authorized to see. 2. A...

Techiee

• Jun 12th, 2013

1. Hiding Unwanted(users do not have right to see those columns e.g login, password column in table) columns from the user.

2. Reduce the complexity of tables from using joins etc. in your query.

Answer Question  Select Best Answer

asifeqbal

 Profile Answers by asifeqbal Questions by asifeqbal

• Mar 18th, 2015

Select * Into From Where 1=2

David Sarkar

 Profile Answers by David Sarkar Questions by David Sarkar

• Dec 12th, 2014

Select * Into New_table FROM Old_Table WHERE 1=0;

Answer Question  Select Best Answer