sap hana - select top expression

sql select sap hana
Inbal Suika Miller picture Inbal Suika Miller · Jan 11, 2017 · Viewed 8.5k times · Source

I have a problem with a stored procedure.

The procedure gets as an argument the number of rows needed, but the following does not work in HANA:

SELECT TOP :NUM_OF_ROWS * FROM TABLE_NAME

I read that TOP in HANA only receives a number, not an expression. Is there another way to do this? My solution for the moment is to select everything and delete the unneeded records on the service, but it's not very efficient.

Answer

Lars Br. picture Lars Br. · Jan 11, 2017

Instead of TOP n you can use the LIMIT n option. That one can bind variables.

Related questions

How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More
SQL SELECT WHERE field contains words

I need a select which would return results like this: SELECT * FROM MyTable WHERE Column1 CONTAINS 'word1 word2 word3' And I need all results, i.e. this includes strings with 'word2 word3 word1' or 'word1 word3 word2' …

Read More
SQL update from one Table to another based on a ID match

I have a database with account numbers and card numbers. I match these to a file to update any card numbers to the account number, so that I am only working with account numbers. I created a view linking the …

Read More