Write SQL query to see first 100 recorders from table?
- 9 Answers
- 7838 Views
- I also Faced
- E-Mail Answers
Answer Posted / ammu
Oracle
select * from table_name where rownum<=100;
SQL server
select top 100 * from table_name;
MySQL
select * from table_name limit 100;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Write notes on apparel testing equipments.
What expected result should come when Enter any sql query like “Select * from hello;” without quotes and with quotes.
Do you know anything about Set Top Boxes?
Hi, I want "Intergraph" placement papers for experienced people which was conducted recently in Hyderabad. Thanks, Purnima.
Can any one share the domain knwoldege of Telecom Jeeva jeevachr@gmail.com
how many meeting in realtime environment? what are they?plz explain?
iam having 2+yr sof exp in manual testing, at present working in chennai,want to relocte to hyd .if any openings let me know.my id : vaniramymail.com
what are the different methods to test a product in 'Japanese' language? NOTE:User is unable to perform basic functionalities while using the app..(copy, paste, text selection etc.)
PLS SEND REAL TIMERS, WHAT IS SOA TESTING..IM TRYING 3+ YR.. I HAVE GOOD KNOWLEDGE ON MANUAL TESTING... NOW IM NEW TO LEARN "SOA TESTING" IS BEST OR NOT? BEFORE LEARNING SOA TESTING ANY SKILLS ARE REQUIRED..... AND NOW WHAT IS THE MARKET FOR SOA TESTING... AND IT IS BASED ON PROGRAMMING OR NOT?
IF ASCII_CODE_OF_ENTERED_CHAR is less than 44 THEN reject it ELSE IF ASCII_CODE_OF_ENTERED_CHAR is greater than 56 THEN reject it ELSE it's a digit, so accept it Which one of the following sets of ASCII codes do you use to test the sample code above WITHOUT redundant coverage?
how to verify a button size (e.g Login Button) on a web page have same dimension prescribed by Client in UI Testing..??
Describe to me what you see as a process. Not a particular process, just the basics of having a process.
How to explain a banking project in interview ? like project discription is Client Online Banking Application provides access to information relating to Banking Online Services provided by Axis to View daily customer transactions, Current and Previous customer statements, Transfer funds from Chequing and Savings accounts ................ From interview point of view can any one explain this project in laymans language
HI, I WANT TO DO A ISTQB FOUNDATION CERTIFICATION FROM HYDERABAD WHICH INSTITUTE WOULD BE GOOD FOR ME,WHERE I CAN TAKE SOME TRAINING SESSIONS FOR CLEARING THIS EXAMINATION.
Can any tell me how a clinical data management system is tested? what are the test scenarios? what are the test cases? work flow.
