drseervi

 Profile Answers by drseervi Questions by drseervi

• May 23rd, 2009

1. Primary key does not allow duplocate.2. We can use below query to find duplicate records select count(*),classifiedID  as tot  from jicka_photos  group by classifiedID  HAVING count(classifiedID) >1 limit 5;Thanks

sampra

 Profile Answers by sampra Questions by sampra

• Feb 14th, 2008

i want to know how u will find primary key in duplicate data .can we find a primary key in duplicate data

Answer Question  Select Best Answer

Which of the following is not a MySQL Operator?a. Between..and..,b. Like,c. IN,d. Is NULL

Bhagya Killi

 Profile Answers by Bhagya Killi Questions by Bhagya Killi

• Jun 14th, 2016

D. Is NULL

vijay

• May 22nd, 2015

Is NULL

Answer Question  Select Best Answer

Amith L

• Jul 11th, 2017

You can find out nth highest salary, In the below code just change the where condition i.e., if you want to get 2nd highest salary, use where (2)"mysql SELECT * FROM CUSTOMER CUS1...

Dan Rusk

• May 1st, 2017

Code
 

Answer Question  Select Best Answer