Select statement

Question

User129610786 posted

Hi All,

    I have requirement to get a data from mysql server using select statement.

 I have table with data as below

In gridview I should get the record only once.

Please help me.

Thanks,

Yaswanth

table name is noofCLs

empid     emailid                                  name                       leaves    month      year

1002	[e-mail]	Allam Bharath	1	July	2013
1003	[e-mail]	Sudhakar Goud V.	1	July	2013

1001	[e-mail]	Allam Sudhakar	0	August	2013
1002	[e-mail]	Allam Bharath	1	June	2013
1003	[e-mail]	Sudhakar Goud V.	1	June	2013

Answer 1

User665793701 posted

Hello Yaswanth,

Using distinct on your select statement will solve your proble.

Select DISTINCT col1,col2...from noofCLs

Answer 2

User1519811487 posted

The data you have there will now allow you to get the record only once, as using a distinct on them columns will still give you the same output as you have.

Are all the columns required in the GridView?

Answer 3

User129610786 posted

HI Mamuns,

Firstly thanks for your reply. But by using Distinct we will not get the data only once because the month or leaves or year may differ with the same empid,name,emailid. so we get it twice.

Answer 4

User129610786 posted

Hi JammoD,

  As explained inabove post i will get the data how many times it is there in the database. Because distincit works if all the columns in the row is equal to the other row. If any one column data is changed then it will be repeated.

Answer 5

User269602965 posted

Since each person can have more than one record, with modifiers like date,

which record do you want to keep.

The one with the latest date?   The one with the highest leave value?

Too bad MySql is a bit sparse in commands for analytics with partitioning, row ordering, etc.

Answer 6

User-1972223072 posted

select distinct empid,emailid,name,leaves,month,year from noofCLs