So many fishes in the sea, but I can not see the right one.
Maybe it helps
In SQL Server
SELECT TOP 1 * FROM GIRLS WHERE SHE IS MY LOVEIn DB2
SELECT * FROM GIRLS WHERE SHE IS MY LOVE FETCH FIRST 1 ROWS ONLYIn MySQL
SELECT * FROM GIRLS WHERE SHE IS MY LOVE LIMIT 1At the beginning, the query keeps simple. But sometimes, it is not easy.
like:
SELECT * FROM GIRLS WHERE SHE IS MY LOVE AND SHE CAN COOK AND SHE IS BEAUTIFUL AND BALABALAWhat's more,
SELECT G,F,S,BEST(ONE) FROM GIRLS WHERE SHE IS MY LOVE AND SHE CAN COOK AND SHE IS BEAUTIFUL AND BALABALA
GROUP BY G,F,SWhat's more.
SELECT G,F,S,BEST(ONE) FROM BOYS WHERE HE IS MY LOVE AND HE CAN COOK AND HE IS HANDSOME AND BALABALA
GROUP BY G,F,S HAVING SUM(balance)>10000... AND COUNT(PROPERTY)>1 AND COUNT(CAR)>1 AND BABABALAAs we know, In a millionaire level table,If there are too many conditions clause, it will affect the performance of the query. The search engine always takes a long time to get what you want.
Now we know why there are still so many fishes in the sea.
For love, keep it simple.
211



被折叠的 条评论
为什么被折叠?



