 Related Questions Latest Answer : 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 ... Read Answers (17) | Asked by : deepti kr misra How to display nth highest record in a table for example? How to display 4th highest (salary) record How to display nth highest record in a table for example? How to display 4th highest (salary) record from customer table? Read Answers (15) | Asked by : Naveen k Sharma Latest Answer : select count(*) from table_name ... Latest Answer : ya that's rightdesc table is easy to useThink this way to desc a table,DB has to save the info some where right? its the information _schema DB where all the info related to Database or table is storedinternally desc will do the same as the below ... Can use rownum.If possible explain.regards,Joe Latest Answer : delete from myTable where (field1, field2) not in ( select distinct(field1), field2 from myTable); ... Read Answers (3) | Asked by : Joe select salary from tablename order by desc limt 4; Latest Answer : select distinct a.sal from emp a where n=(select count(distinct b.sal) from emp b where a.sal Read Answers (4) | Asked by : Vishwapati Mishra Is it required to use Index when the MySQL table has only 100 rows? Justify your answer Latest Answer : For 100 rows may be no need to use the index. If a table having huge number of records with table fields also having more, that time indexing is needed to execute the query fast and reliable. ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1 
0